{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["RWJF Population Model","Update Preparations","Data Dictionary","Input","Drop Down Lists","Macro_Data"],"not_rendered":{"charts":4,"images":0,"macros":1,"external_links":0,"defined_names":5,"comments":0,"pivot_tables":1},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"part_too_large","date_system":"1900"}

{"sheet":"RWJF Population Model","index":0,"n_rows":189,"n_cols":99,"rows_kept":189,"cut":false,"hidden":false,"merged":[[155,40,155,50],[156,40,156,50],[157,40,157,50],[12,56,13,97],[12,1,13,11],[110,11,110,27],[111,11,111,27],[53,25,53,41],[97,39,97,44],[98,39,98,44],[99,39,99,44],[152,40,152,50],[153,40,153,50],[154,40,154,50],[55,10,55,22],[51,10,51,22],[49,10,49,22],[47,10,47,22],[57,88,57,96],[55,88,55,96],[53,88,53,96],[51,88,51,96],[49,88,49,96],[47,88,47,96],[57,78,57,86],[55,78,55,86],[53,78,53,86],[51,78,51,86],[49,78,49,86],[47,78,47,86],[57,68,57,76],[55,68,55,76],[53,68,53,76],[51,68,51,76],[49,68,49,76],[47,68,47,76],[53,4,53,22],[182,28,182,38],[183,28,183,38],[184,28,184,38],[185,28,185,38],[186,28,186,38],[187,28,187,38],[170,28,170,38],[171,28,171,38],[172,28,172,38],[173,28,173,38],[174,28,174,38],[175,28,175,38],[176,28,176,38],[177,28,177,38],[178,28,178,38],[95,11,95,27],[96,11,96,27],[97,11,97,27],[158,28,158,38],[163,28,163,38],[164,28,164,38],[165,28,165,38],[161,28,161,38],[168,40,168,50],[169,40,169,50],[170,40,170,50],[171,40,171,50],[179,28,179,38],[180,28,180,38],[181,28,181,38],[166,28,166,38],[167,28,167,38],[168,28,168,38],[127,59,127,72],[188,28,188,38],[152,28,152,38],[153,28,153,38],[154,28,154,38],[155,28,155,38],[156,28,156,38],[131,59,131,72],[132,59,132,72],[133,59,133,72],[134,59,134,72],[135,59,135,72],[133,42,133,55],[132,42,132,55],[161,40,161,50],[162,40,162,50],[163,40,163,50],[164,40,164,50],[165,40,165,50],[169,28,169,38],[150,28,150,38],[157,28,157,38],[166,40,166,50],[167,40,167,50],[57,58,57,66],[55,58,55,66],[53,58,53,66],[51,58,51,66],[49,58,49,66],[47,58,47,66],[55,45,55,56],[53,45,53,56],[51,45,51,56],[49,45,49,56],[57,45,57,56],[162,28,162,38],[159,28,159,38],[160,28,160,38],[185,2,185,17],[180,19,180,21],[181,19,181,21],[182,19,182,21],[183,19,183,21],[184,19,184,21],[171,2,171,17],[172,2,172,17],[173,2,173,17],[174,2,174,17],[175,2,175,17],[176,2,176,17],[177,2,177,17],[178,2,178,17],[175,19,175,21],[167,19,167,21],[168,19,168,21],[169,19,169,21],[170,19,170,21],[171,19,171,21],[172,19,172,21],[87,72,87,77],[97,72,97,77],[118,76,118,89],[98,72,98,77],[99,72,99,77],[100,72,100,77],[186,2,186,17],[187,2,187,17],[188,2,188,17],[166,2,166,17],[167,2,167,17],[168,2,168,17],[169,2,169,17],[170,2,170,17],[176,19,176,21],[177,19,177,21],[178,19,178,21],[179,19,179,21],[179,2,179,17],[180,2,180,17],[181,2,181,17],[182,2,182,17],[183,2,183,17],[184,2,184,17],[125,76,125,89],[126,76,126,89],[127,76,127,89],[128,76,128,89],[129,76,129,89],[130,76,130,89],[131,76,131,89],[122,76,122,89],[123,76,123,89],[124,76,124,89],[129,59,129,72],[140,25,140,38],[137,76,137,89],[138,76,138,89],[139,76,139,89],[140,76,140,89],[136,59,136,72],[137,59,137,72],[138,59,138,72],[139,59,139,72],[140,59,140,72],[139,42,139,55],[140,42,140,55],[138,42,138,55],[137,42,137,55],[136,42,136,55],[130,59,130,72],[136,76,136,89],[132,76,132,89],[133,76,133,89],[134,76,134,89],[135,76,135,89],[129,42,129,55],[130,42,130,55],[120,76,120,89],[121,76,121,89],[124,59,124,72],[120,25,120,38],[121,25,121,38],[122,25,122,38],[123,25,123,38],[120,42,120,55],[121,42,121,55],[122,42,122,55],[123,42,123,55],[101,39,101,44],[109,39,109,44],[110,39,110,44],[111,39,111,44],[102,39,102,44],[103,39,103,44],[104,39,104,44],[105,39,105,44],[106,39,106,44],[128,59,128,72],[124,42,124,55],[125,42,125,55],[126,42,126,55],[127,42,127,55],[128,42,128,55],[105,11,105,27],[106,11,106,27],[111,45,111,50],[107,11,107,27],[108,11,108,27],[127,11,127,21],[128,11,128,21],[108,33,108,38],[107,33,107,38],[120,59,120,72],[121,59,121,72],[122,59,122,72],[123,59,123,72],[118,59,118,72],[118,25,118,38],[109,11,109,27],[125,59,125,72],[126,59,126,72],[49,25,49,41],[137,11,137,21],[138,11,138,21],[87,11,87,27],[88,11,88,27],[89,11,89,27],[90,11,90,27],[91,11,91,27],[92,11,92,27],[102,11,102,27],[103,11,103,27],[104,11,104,27],[98,11,98,27],[99,11,99,27],[100,11,100,27],[101,11,101,27],[93,11,93,27],[94,11,94,27],[92,39,92,44],[93,39,93,44],[110,33,110,38],[106,33,106,38],[85,33,85,62],[123,11,123,21],[18,40,18,49],[22,40,22,49],[24,40,24,49],[35,40,35,49],[39,40,39,49],[32,40,32,49],[26,40,26,49],[46,25,47,41],[24,9,24,38],[22,9,22,38],[39,2,39,38],[18,8,18,38],[26,10,26,38],[20,40,20,49],[35,5,35,38],[20,2,20,38],[47,45,47,56],[45,45,46,96],[27,73,36,97],[37,73,39,97],[18,73,26,97],[85,66,85,89],[55,25,55,41],[90,78,90,83],[91,78,91,83],[86,39,86,44],[86,45,86,50],[86,51,86,56],[87,39,87,44],[88,39,88,44],[89,39,89,44],[90,39,90,44],[91,39,91,44],[87,78,87,83],[88,78,88,83],[89,78,89,83],[88,51,88,56],[89,51,89,56],[90,51,90,56],[91,51,91,56],[87,51,87,56],[86,84,86,89],[88,72,88,77],[89,72,89,77],[90,72,90,77],[91,72,91,77],[92,66,92,71],[97,45,97,50],[98,45,98,50],[99,45,99,50],[92,51,92,56],[93,51,93,56],[94,51,94,56],[95,51,95,56],[96,51,96,56],[99,57,99,62],[97,57,97,62],[98,57,98,62],[92,72,92,77],[93,72,93,77],[94,72,94,77],[95,72,95,77],[93,66,93,71],[100,66,100,71],[101,66,101,71],[86,57,86,62],[86,66,86,71],[86,72,86,77],[86,78,86,83],[100,57,100,62],[101,57,101,62],[92,45,92,50],[92,57,92,62],[93,57,93,62],[94,57,94,62],[95,57,95,62],[96,57,96,62],[101,51,101,56],[97,51,97,56],[98,51,98,56],[99,51,99,56],[100,51,100,56],[100,45,100,50],[101,45,101,50],[88,66,88,71],[89,66,89,71],[96,72,96,77],[90,66,90,71],[91,66,91,71],[87,57,87,62],[88,57,88,62],[89,57,89,62],[90,57,90,62],[91,57,91,62],[87,66,87,71],[109,84,109,89],[107,72,107,77],[108,72,108,77],[109,72,109,77],[102,72,102,77],[103,72,103,77],[104,72,104,77],[105,72,105,77],[106,72,106,77],[109,78,109,83],[102,78,102,83],[103,78,103,83],[104,78,104,83],[105,78,105,83],[106,78,106,83],[107,78,107,83],[108,78,108,83],[87,84,87,89],[88,84,88,89],[102,84,102,89],[103,84,103,89],[104,84,104,89],[105,84,105,89],[106,84,106,89],[97,84,97,89],[89,84,89,89],[90,84,90,89],[91,84,91,89],[96,84,96,89],[98,84,98,89],[99,84,99,89],[100,84,100,89],[101,84,101,89],[94,78,94,83],[95,78,95,83],[96,78,96,83],[107,84,107,89],[108,84,108,89],[92,84,92,89],[93,84,93,89],[94,84,94,89],[95,84,95,89],[97,78,97,83],[98,78,98,83],[99,78,99,83],[100,78,100,83],[101,78,101,83],[92,78,92,83],[93,78,93,83],[110,57,110,62],[111,57,111,62],[102,57,102,62],[103,57,103,62],[104,57,104,62],[105,57,105,62],[106,57,106,62],[109,57,109,62],[107,51,107,56],[108,51,108,56],[109,51,109,56],[110,51,110,56],[109,33,109,38],[125,11,125,21],[126,11,126,21],[124,25,124,38],[125,25,125,38],[126,25,126,38],[111,33,111,38],[118,11,118,21],[120,11,120,21],[121,11,121,21],[122,11,122,21],[124,11,124,21],[129,11,129,21],[130,11,130,21],[131,11,131,21],[127,25,127,38],[128,25,128,38],[129,25,129,38],[130,25,130,38],[101,72,101,77],[94,66,94,71],[95,66,95,71],[96,66,96,71],[107,66,107,71],[108,66,108,71],[107,57,107,62],[108,57,108,62],[109,66,109,71],[102,66,102,71],[103,66,103,71],[104,66,104,71],[105,66,105,71],[106,66,106,71],[97,66,97,71],[98,66,98,71],[99,66,99,71],[102,45,102,50],[103,45,103,50],[104,45,104,50],[105,45,105,50],[106,45,106,50],[109,45,109,50],[110,45,110,50],[107,45,107,50],[135,42,135,55],[134,42,134,55],[111,51,111,56],[118,42,118,55],[173,19,173,21],[174,19,174,21],[150,2,150,17],[152,2,152,17],[153,2,153,17],[154,2,154,17],[155,2,155,17],[156,2,156,17],[165,2,165,17],[157,2,157,17],[158,2,158,17],[159,2,159,17],[160,2,160,17],[161,2,161,17],[162,2,162,17],[163,2,163,17],[164,2,164,17],[159,40,159,50],[160,40,160,50],[131,42,131,55],[131,25,131,38],[132,25,132,38],[133,25,133,38],[134,25,134,38],[135,25,135,38],[136,25,136,38],[137,25,137,38],[138,25,138,38],[139,25,139,38],[146,9,147,42],[152,23,152,26],[153,23,153,26],[154,23,154,26],[155,23,155,26],[156,23,156,26],[150,40,150,50],[139,11,139,21],[140,11,140,21],[132,11,132,21],[135,11,135,21],[136,11,136,21],[87,33,87,38],[86,33,86,38],[37,40,37,49],[100,33,100,38],[99,33,99,38],[98,33,98,38],[97,33,97,38],[96,33,96,38],[95,33,95,38],[94,33,94,38],[93,33,93,38],[92,33,92,38],[100,39,100,44],[87,45,87,50],[88,45,88,50],[89,45,89,50],[90,45,90,50],[91,45,91,50],[37,2,37,38],[93,45,93,50],[94,45,94,50],[95,45,95,50],[96,45,96,50],[51,25,51,41],[185,19,185,21],[186,19,186,21],[187,19,187,21],[188,19,188,21],[185,40,185,50],[186,40,186,50],[187,40,187,50],[188,40,188,50],[152,19,152,21],[153,19,153,21],[154,19,154,21],[155,19,155,21],[161,19,161,21],[160,19,160,21],[159,19,159,21],[158,19,158,21],[157,19,157,21],[156,19,156,21],[162,19,162,21],[163,19,163,21],[164,19,164,21],[165,19,165,21],[166,19,166,21],[172,40,172,50],[62,76,63,81],[64,73,65,75],[64,76,65,81],[181,40,181,50],[182,40,182,50],[183,40,183,50],[184,40,184,50],[177,40,177,50],[178,40,178,50],[179,40,179,50],[180,40,180,50],[173,40,173,50],[174,40,174,50],[175,40,175,50],[176,40,176,50],[108,45,108,50],[102,51,102,56],[103,51,103,56],[104,51,104,56],[105,51,105,56],[106,51,106,56],[94,39,94,44],[95,39,95,44],[96,39,96,44],[157,23,157,26],[158,23,158,26],[159,23,159,26],[160,23,160,26],[161,23,161,26],[162,23,162,26],[163,23,163,26],[164,23,164,26],[62,73,63,75],[105,33,105,38],[104,33,104,38],[150,19,150,26],[107,39,107,44],[108,39,108,44],[133,11,133,21],[134,11,134,21],[103,33,103,38],[102,33,102,38],[101,33,101,38],[91,33,91,38],[90,33,90,38],[89,33,89,38],[88,33,88,38],[158,40,158,50],[165,23,165,26],[166,23,166,26],[167,23,167,26],[168,23,168,26],[188,23,188,26],[169,23,169,26],[187,23,187,26],[170,23,170,26],[171,23,171,26],[172,23,172,26],[173,23,173,26],[174,23,174,26],[186,23,186,26],[185,23,185,26],[175,23,175,26],[176,23,176,26],[177,23,177,26],[184,23,184,26],[183,23,183,26],[178,23,178,26],[179,23,179,26],[180,23,180,26],[181,23,181,26],[182,23,182,26]]}
[null,"[insert purpose of this tool here] - Analysis"]
[]
[null,"Baseline population determined by the following criteria: "]
[null,null,null,"(1) Criteria may include line of business, member ages and date range restrictions, including which timeframe is \"year 1\" and which is \"year 2\""]
[null,null,null,"(2) Criteria may include membership restrictions (e.g., must have been a member for at least 2 months in both year 1 and year 2)"]
[null,null,null,"(3) Criteria may include geographic location limitations"]
[]
[null,"Dynamic variables are highlighted in yellow. Tables are modified when new variables are selected."]
[1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1]
[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,72,73,74,75,76,77,78,79,80,81,82,83,84,85,86,87,88,89,90,91,92,93,94,95,96,97,98,100]
[]
[]
[null,"Enter Assumptions:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"<=== Click to Reset Criteria to Baseline Population"]
[]
[]
[null,null,"Which crossection of the population would you like to analyze?"]
[]
[]
[null,null,null,null,null,null,null,null,"Which group should the population be associated with?:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Group A",null,null,null,null,null,null,null,null,null,null,"<=== Select Group Criteria"]
[]
[null,null,"Enter the minimum # of \"medically complex\" criteria the member met in 2011?:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"<=== Select Criteria Value (at least) - 2011"]
[]
[null,null,null,null,null,null,null,null,null,"Which Year 1 PMPM Percentile do you want to isolate?:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,50,null,null,null,null,null,null,null,null,null,null,"<=== Select Percentile by PMPM (at least) - Yr 1"]
[]
[null,null,null,null,null,null,null,null,null,"Which Year 2 PMPM Percentile do you want to isolate?:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,50,null,null,null,null,null,null,null,null,null,null,"<=== Select Percentile by PMPM (at least) - Yr 2"]
[]
[null,null,null,null,null,null,null,null,null,null,"The 2 Year Period PMPM of selected population crossection is:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($AO$33=2010,Macro_Data!$N$8,IF($AO$33=2011,Macro_Data!$O$8,IF($AO$33=\"Total\",Macro_Data!$Q$8,\"\")))","v":291.61365566037739}]
[]
[]
[null,null,"How would you like to further limit the population crossection based on assumptions regarding \"episodic spend\" members?"]
[]
[]
[null,null,null,null,null,null,null,null,null,"Year:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total",null,null,null,null,null,null,null,null,null,null,"<=== Select Desired Year for PMPM Threshold"]
[]
[]
[null,null,null,null,null,"% the Yr 2 PMPM should be increased to set  \"episodic spend\" threshold?:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,"<=== Select % Markup from Yr 2 PMPM"]
[]
[null,null,"New PMPM threshold (lower bound) that serves to identify \"episodic spending\":",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$AO$27*(1+$AO$36)","v":291.61365566037739}]
[]
[null,null,"Minimum # of Months that member spend exceeded \"episodic spend\" threshold:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"<=== Select # of Months (0-24)"]
[]
[]
[null,null,null,null,"What are the demographics of the selected population?"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PMPM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTIF(Input!$IP$2:$IP$25001,1)","v":18}]
[null,null,null,null,null,null,null,null,null,null,"Total Members:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Type",null,null,null,null,null,null,null,null,null,null,null,null,"Year 1",null,null,null,null,null,null,null,null,null,"Year 2",null,null,null,null,null,null,null,null,null,"D",null,null,null,null,null,null,null,null,null,"2 YR Period Total"]
[]
[null,null,null,null,null,null,null,null,null,null,"Average Age of Population:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AVERAGEIF(Input!$IP$2:$IP$25001,1,Input!$C$2:$C$25001)","v":16.277777777777779},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Medical",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUMIF(Input!$IP$2:$IP$25001,1,Input!$DY$2:$DY$25001)/SUMIF(Input!$IP$2:$IP$25001,1,Input!$EQ$2:$EQ$25001)","v":81.63319444444447},null,null,null,null,null,null,null,null,null,{"$f":"SUMIF(Input!$IP$2:$IP$25001,1,Input!$DZ$2:$DZ$25001)/SUMIF(Input!$IP$2:$IP$25001,1,Input!$ER$2:$ER$25001)","v":223.93716346153849},null,null,null,null,null,null,null,null,null,{"$f":"BQ50-BG50","v":142.303969017094},null,null,null,null,null,null,null,null,null,{"$f":"SUMIF(Input!$IP$2:$IP$25001,1,Input!$JB$2:$JB$25001)/SUMIF(Input!$IP$2:$IP$25001,1,Input!$JF$2:$JF$25001)","v":151.44268867924526}]
[]
[null,null,null,null,null,null,null,null,null,null,"% Female:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUMIF(Input!$IP$2:$IP$25001,1,Input!$IR$2:$IR$25001)/$Z$47","v":0.33333333333333331},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rx",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUMIF(Input!$IP$2:$IP$25001,1,Input!$EC$2:$EC$25001)/SUMIF(Input!$IP$2:$IP$25001,1,Input!$EQ$2:$EQ$25001)","v":123.15805555555556},null,null,null,null,null,null,null,null,null,{"$f":"SUMIF(Input!$IP$2:$IP$25001,1,Input!$ED$2:$ED$25001)/SUMIF(Input!$IP$2:$IP$25001,1,Input!$ER$2:$ER$25001)","v":157.83822115384615},null,null,null,null,null,null,null,null,null,{"$f":"BQ52-BG52","v":34.680165598290586},null,null,null,null,null,null,null,null,null,{"$f":"SUMIF(Input!$IP$2:$IP$25001,1,Input!$JC$2:$JC$25001)/SUMIF(Input!$IP$2:$IP$25001,1,Input!$JF$2:$JF$25001)","v":140.1709669811321}]
[]
[null,null,null,null,"Population Yr 1 - Yr 2 Medical & Rx PGA:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUMIF(Input!$IP$2:$IP$25001,1,Input!$JD$2:$JD$25001)","v":123644.19},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Med + Rx Total",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUMIF(Input!$IP$2:$IP$25001,1,Input!$EG$2:$EG$25001)/SUMIF(Input!$IP$2:$IP$25001,1,Input!$EQ$2:$EQ$25001)","v":204.79124999999999},null,null,null,null,null,null,null,null,null,{"$f":"SUMIF(Input!$IP$2:$IP$25001,1,Input!$EJ$2:$EJ$25001)/SUMIF(Input!$IP$2:$IP$25001,1,Input!$ER$2:$ER$25001)","v":381.77538461538472},null,null,null,null,null,null,null,null,null,{"$f":"BQ54-BG54","v":176.98413461538473},null,null,null,null,null,null,null,null,null,{"$f":"SUMIF(Input!$IP$2:$IP$25001,1,Input!$JD$2:$JD$25001)/SUMIF(Input!$IP$2:$IP$25001,1,Input!$JF$2:$JF$25001)","v":291.61365566037739}]
[]
[null,null,null,null,null,null,null,null,null,null,"Total Member Months:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUMIF(Input!$IP$2:$IP$25001,1,Input!$JF$2:$JF$25001)","v":424},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Behavioral Health (CCBH)",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUMIF(Input!$IP$2:$IP$25001,1,Input!$EO$2:$EO$25001)/SUMIF(Input!$IP$2:$IP$25001,1,Input!$EQ$2:$EQ$25001)","v":302.24013888888885},null,null,null,null,null,null,null,null,null,{"$f":"SUMIF(Input!$IP$2:$IP$25001,1,Input!$EP$2:$EP$25001)/SUMIF(Input!$IP$2:$IP$25001,1,Input!$ER$2:$ER$25001)","v":398.143125},null,null,null,null,null,null,null,null,null,{"$f":"BQ56-BG56","v":95.902986111111147},null,null,null,null,null,null,null,null,null,{"$f":"SUMIF(Input!$IP$2:$IP$25001,1,Input!$MB$2:$MB$25001)/SUMIF(Input!$IP$2:$IP$25001,1,Input!$JF$2:$JF$25001)","v":349.28688679245289}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Grand Total",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUMIF(Input!$IP$2:$IP$25001,1,Input!$MC$2:$MC$25001)/SUMIF(Input!$IP$2:$IP$25001,1,Input!$EQ$2:$EQ$25001)","v":507.03138888888901},null,null,null,null,null,null,null,null,null,{"$f":"SUMIF(Input!$IP$2:$IP$25001,1,Input!$MD$2:$MD$25001)/SUMIF(Input!$IP$2:$IP$25001,1,Input!$ER$2:$ER$25001)","v":779.91850961538455},null,null,null,null,null,null,null,null,null,{"$f":"BQ58-BG58","v":272.88712072649554},null,null,null,null,null,null,null,null,null,{"$f":"SUMIF(Input!$IP$2:$IP$25001,1,Input!$ME$2:$ME$25001)/SUMIF(Input!$IP$2:$IP$25001,1,Input!$JF$2:$JF$25001)","v":640.90054245283034}]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N=",null,null,{"$f":"Macro_Data!U32","v":18}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Macro_Data!T33","v":""},null,null,{"$f":"Macro_Data!U33","v":""}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"What types of services does the selected population utilize?"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PMPM",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Annual Units / 1,000"]
[null,null,null,null,null,null,null,null,null,null,null,"UPMC HP Financial Service Type",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Year 1",null,null,null,null,null,"Year 2",null,null,null,null,null,"% Year 2 $",null,null,null,null,null,"D",null,null,null,null,null,"% D",null,null,null,null,null,null,null,null,"Year 1",null,null,null,null,null,"Year 2",null,null,null,null,null,"D",null,null,null,null,null,"% D"]
[null,null,null,null,null,null,null,null,null,null,null,"Inpatient Facility - Medical Surgical",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUMIF(Input!$IP$2:$IP$25001,1,Input!$I$2:$I$25001)/SUMIF(Input!$IP$2:$IP$25001,1,Input!$EQ$2:$EQ$25001)","v":6.2079629629629629},null,null,null,null,null,{"$f":"SUMIF(Input!$IP$2:$IP$25001,1,Input!$J$2:$J$25001)/SUMIF(Input!$IP$2:$IP$25001,1,Input!$ER$2:$ER$25001)","v":36.768076923076926},null,null,null,null,null,{"$f":"AN88/$AN$112","v":9.6308139300595591E-2},null,null,null,null,null,{"$f":"AN88-AH88","v":30.560113960113963},null,null,null,null,null,{"$f":"IFERROR(AZ88/AH88,\"\")","v":4.9227281384307906},null,null,null,null,null,null,null,null,{"$f":"(SUMIF(Input!$IP$2:$IP$25001,1,Input!$BE$2:$BE$25001)/SUMIF(Input!$IP$2:$IP$25001,1,Input!$EQ$2:$EQ$25001))*12000","v":55.55555555555555},null,null,null,null,null,{"$f":"(SUMIF(Input!$IP$2:$IP$25001,1,Input!$BF$2:$BF$25001)/SUMIF(Input!$IP$2:$IP$25001,1,Input!$ER$2:$ER$25001))*12000","v":57.692307692307693},null,null,null,null,null,{"$f":"BU88-BO88","v":2.1367521367521434},null,null,null,null,null,{"$f":"IFERROR(CA88/BO88,\"\")","v":3.8461538461538582E-2}]
[null,null,null,null,null,null,null,null,null,null,null,"Inpatient Facility -Skilled Nursing",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUMIF(Input!$IP$2:$IP$25001,1,Input!$M$2:$M$25001)/SUMIF(Input!$IP$2:$IP$25001,1,Input!$EQ$2:$EQ$25001)","v":0},null,null,null,null,null,{"$f":"SUMIF(Input!$IP$2:$IP$25001,1,Input!$N$2:$N$25001)/SUMIF(Input!$IP$2:$IP$25001,1,Input!$ER$2:$ER$25001)","v":0},null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,{"$f":"IFERROR(AZ89/AH89,\"\")","v":""},null,null,null,null,null,null,null,null,{"$f":"(SUMIF(Input!$IP$2:$IP$25001,1,Input!$BI$2:$BI$25001)/SUMIF(Input!$IP$2:$IP$25001,1,Input!$EQ$2:$EQ$25001))*12000","v":0},null,null,null,null,null,{"$f":"(SUMIF(Input!$IP$2:$IP$25001,1,Input!$BJ$2:$BJ$25001)/SUMIF(Input!$IP$2:$IP$25001,1,Input!$ER$2:$ER$25001))*12000","v":0},null,null,null,null,null,{"$f":"BU89-BO89","v":0},null,null,null,null,null,{"$f":"IFERROR(CA89/BO89,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,"Inpatient Facility - Rehabilitation",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUMIF(Input!$IP$2:$IP$25001,1,Input!$K$2:$K$25001)/SUMIF(Input!$IP$2:$IP$25001,1,Input!$EQ$2:$EQ$25001)","v":0},null,null,null,null,null,{"$f":"SUMIF(Input!$IP$2:$IP$25001,1,Input!$L$2:$L$25001)/SUMIF(Input!$IP$2:$IP$25001,1,Input!$ER$2:$ER$25001)","v":0},null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,"",null,null,null,null,null,null,null,null,{"$f":"(SUMIF(Input!$IP$2:$IP$25001,1,Input!$BG$2:$BG$25001)/SUMIF(Input!$IP$2:$IP$25001,1,Input!$EQ$2:$EQ$25001))*12000","v":0},null,null,null,null,null,{"$f":"(SUMIF(Input!$IP$2:$IP$25001,1,Input!$BH$2:$BH$25001)/SUMIF(Input!$IP$2:$IP$25001,1,Input!$ER$2:$ER$25001))*12000","v":0},null,null,null,null,null,{"$f":"BU90-BO90","v":0},null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,"Inpatient Facility - Other",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUMIF(Input!$IP$2:$IP$25001,1,Input!$O$2:$O$25001)/SUMIF(Input!$IP$2:$IP$25001,1,Input!$EQ$2:$EQ$25001)","v":0},null,null,null,null,null,{"$f":"SUMIF(Input!$IP$2:$IP$25001,1,Input!$P$2:$P$25001)/SUMIF(Input!$IP$2:$IP$25001,1,Input!$ER$2:$ER$25001)","v":28.28846153846154},null,null,null,null,null,7.4097133231783477E-2,null,null,null,null,null,28.28846153846154,null,null,null,null,null,"",null,null,null,null,null,null,null,null,{"$f":"(SUMIF(Input!$IP$2:$IP$25001,1,Input!$BK$2:$BK$25001)/SUMIF(Input!$IP$2:$IP$25001,1,Input!$EQ$2:$EQ$25001))*12000","v":0},null,null,null,null,null,{"$f":"(SUMIF(Input!$IP$2:$IP$25001,1,Input!$BL$2:$BL$25001)/SUMIF(Input!$IP$2:$IP$25001,1,Input!$ER$2:$ER$25001))*12000","v":57.692307692307693},null,null,null,null,null,57.692307692307693,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,"Observations",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUMIF(Input!$IP$2:$IP$25001,1,Input!$Q$2:$Q$25001)/SUMIF(Input!$IP$2:$IP$25001,1,Input!$EQ$2:$EQ$25001)","v":5.8381944444444445},null,null,null,null,null,{"$f":"SUMIF(Input!$IP$2:$IP$25001,1,Input!$R$2:$R$25001)/SUMIF(Input!$IP$2:$IP$25001,1,Input!$ER$2:$ER$25001)","v":10.817307692307692},null,null,null,null,null,2.8334219879590894E-2,null,null,null,null,null,4.9791132478632472,null,null,null,null,null,0.85285156142774776,null,null,null,null,null,null,null,null,{"$f":"(SUMIF(Input!$IP$2:$IP$25001,1,Input!$BM$2:$BM$25001)/SUMIF(Input!$IP$2:$IP$25001,1,Input!$EQ$2:$EQ$25001))*12000","v":55.55555555555555},null,null,null,null,null,{"$f":"(SUMIF(Input!$IP$2:$IP$25001,1,Input!$BN$2:$BN$25001)/SUMIF(Input!$IP$2:$IP$25001,1,Input!$ER$2:$ER$25001))*12000","v":57.692307692307693},null,null,null,null,null,2.1367521367521434,null,null,null,null,null,3.8461538461538582E-2]
[null,null,null,null,null,null,null,null,null,null,null,"Emergency Room",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUMIF(Input!$IP$2:$IP$25001,1,Input!$S$2:$S$25001)/SUMIF(Input!$IP$2:$IP$25001,1,Input!$EQ$2:$EQ$25001)","v":15.365925925925925},null,null,null,null,null,{"$f":"SUMIF(Input!$IP$2:$IP$25001,1,Input!$T$2:$T$25001)/SUMIF(Input!$IP$2:$IP$25001,1,Input!$ER$2:$ER$25001)","v":24.170432692307696},null,null,null,null,null,6.3310610548288557E-2,null,null,null,null,null,8.8045067663817704,null,null,null,null,null,0.57298901535939983,null,null,null,null,null,null,null,null,{"$f":"(SUMIF(Input!$IP$2:$IP$25001,1,Input!$BO$2:$BO$25001)/SUMIF(Input!$IP$2:$IP$25001,1,Input!$EQ$2:$EQ$25001))*12000","v":666.66666666666663},null,null,null,null,null,{"$f":"(SUMIF(Input!$IP$2:$IP$25001,1,Input!$BP$2:$BP$25001)/SUMIF(Input!$IP$2:$IP$25001,1,Input!$ER$2:$ER$25001))*12000","v":980.76923076923083},null,null,null,null,null,314.1025641025642,null,null,null,null,null,0.47115384615384631]
[null,null,null,null,null,null,null,null,null,null,null,"Outpatient Surgery",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUMIF(Input!$IP$2:$IP$25001,1,Input!$U$2:$U$25001)/SUMIF(Input!$IP$2:$IP$25001,1,Input!$EQ$2:$EQ$25001)","v":4.8765740740740737},null,null,null,null,null,{"$f":"SUMIF(Input!$IP$2:$IP$25001,1,Input!$V$2:$V$25001)/SUMIF(Input!$IP$2:$IP$25001,1,Input!$ER$2:$ER$25001)","v":6.0290384615384616},null,null,null,null,null,1.5792108932356518E-2,null,null,null,null,null,1.1524643874643878,null,null,null,null,null,0.23632664447596008,null,null,null,null,null,null,null,null,{"$f":"(SUMIF(Input!$IP$2:$IP$25001,1,Input!$BQ$2:$BQ$25001)/SUMIF(Input!$IP$2:$IP$25001,1,Input!$EQ$2:$EQ$25001))*12000","v":166.66666666666666},null,null,null,null,null,{"$f":"(SUMIF(Input!$IP$2:$IP$25001,1,Input!$BR$2:$BR$25001)/SUMIF(Input!$IP$2:$IP$25001,1,Input!$ER$2:$ER$25001))*12000","v":115.38461538461539},null,null,null,null,null,-51.28205128205127,null,null,null,null,null,-0.30769230769230765]
[null,null,null,null,null,null,null,null,null,null,null,"Outpatient Facility - Other",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUMIF(Input!$IP$2:$IP$25001,1,Input!$W$2:$W$25001)/SUMIF(Input!$IP$2:$IP$25001,1,Input!$EQ$2:$EQ$25001)","v":1.9200925925925927},null,null,null,null,null,{"$f":"SUMIF(Input!$IP$2:$IP$25001,1,Input!$X$2:$X$25001)/SUMIF(Input!$IP$2:$IP$25001,1,Input!$ER$2:$ER$25001)","v":21.374999999999996},null,null,null,null,null,5.5988418482071603E-2,null,null,null,null,null,19.454907407407404,null,null,null,null,null,10.132275642571248,null,null,null,null,null,null,null,null,{"$f":"(SUMIF(Input!$IP$2:$IP$25001,1,Input!$BS$2:$BS$25001)/SUMIF(Input!$IP$2:$IP$25001,1,Input!$EQ$2:$EQ$25001))*12000","v":388.88888888888886},null,null,null,null,null,{"$f":"(SUMIF(Input!$IP$2:$IP$25001,1,Input!$BT$2:$BT$25001)/SUMIF(Input!$IP$2:$IP$25001,1,Input!$ER$2:$ER$25001))*12000","v":2538.4615384615386},null,null,null,null,null,2149.5726495726499,null,null,null,null,null,5.5274725274725292]
[null,null,null,null,null,null,null,null,null,null,null,"Therapy Services",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUMIF(Input!$IP$2:$IP$25001,1,Input!$Y$2:$Y$25001)/SUMIF(Input!$IP$2:$IP$25001,1,Input!$EQ$2:$EQ$25001)","v":0.15740740740740741},null,null,null,null,null,{"$f":"SUMIF(Input!$IP$2:$IP$25001,1,Input!$Z$2:$Z$25001)/SUMIF(Input!$IP$2:$IP$25001,1,Input!$ER$2:$ER$25001)","v":2.0421153846153848},null,null,null,null,null,5.3489969938022358E-3,null,null,null,null,null,1.8847079772079773,null,null,null,null,null,11.973438914027149,null,null,null,null,null,null,null,null,{"$f":"(SUMIF(Input!$IP$2:$IP$25001,1,Input!$BU$2:$BU$25001)/SUMIF(Input!$IP$2:$IP$25001,1,Input!$EQ$2:$EQ$25001))*12000","v":55.55555555555555},null,null,null,null,null,{"$f":"(SUMIF(Input!$IP$2:$IP$25001,1,Input!$BV$2:$BV$25001)/SUMIF(Input!$IP$2:$IP$25001,1,Input!$ER$2:$ER$25001))*12000","v":750},null,null,null,null,null,694.44444444444446,null,null,null,null,null,12.500000000000002]
[null,null,null,null,null,null,null,null,null,null,null,"Diagnostics - Lab services",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUMIF(Input!$IP$2:$IP$25001,1,Input!$AA$2:$AA$25001)/SUMIF(Input!$IP$2:$IP$25001,1,Input!$EQ$2:$EQ$25001)","v":1.8743518518518518},null,null,null,null,null,{"$f":"SUMIF(Input!$IP$2:$IP$25001,1,Input!$AB$2:$AB$25001)/SUMIF(Input!$IP$2:$IP$25001,1,Input!$ER$2:$ER$25001)","v":10.378749999999998},null,null,null,null,null,2.7185487640739209E-2,null,null,null,null,null,8.5043981481481463,null,null,null,null,null,4.5372474435607364,null,null,null,null,null,null,null,null,{"$f":"(SUMIF(Input!$IP$2:$IP$25001,1,Input!$BW$2:$BW$25001)/SUMIF(Input!$IP$2:$IP$25001,1,Input!$EQ$2:$EQ$25001))*12000","v":944.44444444444446},null,null,null,null,null,{"$f":"(SUMIF(Input!$IP$2:$IP$25001,1,Input!$BX$2:$BX$25001)/SUMIF(Input!$IP$2:$IP$25001,1,Input!$ER$2:$ER$25001))*12000","v":2192.3076923076924},null,null,null,null,null,1247.863247863248,null,null,null,null,null,1.321266968325792]
[null,null,null,null,null,null,null,null,null,null,null,"Diagnostics - High Tech Radiology",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUMIF(Input!$IP$2:$IP$25001,1,Input!$AC$2:$AC$25001)/SUMIF(Input!$IP$2:$IP$25001,1,Input!$EQ$2:$EQ$25001)","v":1.9505092592592592},null,null,null,null,null,{"$f":"SUMIF(Input!$IP$2:$IP$25001,1,Input!$AD$2:$AD$25001)/SUMIF(Input!$IP$2:$IP$25001,1,Input!$ER$2:$ER$25001)","v":2.1447596153846153},null,null,null,null,null,5.6178572579930197E-3,null,null,null,null,null,0.19425035612535613,null,null,null,null,null,9.958955857462895E-2,null,null,null,null,null,null,null,null,{"$f":"(SUMIF(Input!$IP$2:$IP$25001,1,Input!$BY$2:$BY$25001)/SUMIF(Input!$IP$2:$IP$25001,1,Input!$EQ$2:$EQ$25001))*12000","v":55.55555555555555},null,null,null,null,null,{"$f":"(SUMIF(Input!$IP$2:$IP$25001,1,Input!$BZ$2:$BZ$25001)/SUMIF(Input!$IP$2:$IP$25001,1,Input!$ER$2:$ER$25001))*12000","v":115.38461538461539},null,null,null,null,null,59.829059829059837,null,null,null,null,null,1.0769230769230771]
[null,null,null,null,null,null,null,null,null,null,null,"Diagnostics - Low Tech Radiology",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUMIF(Input!$IP$2:$IP$25001,1,Input!$AE$2:$AE$25001)/SUMIF(Input!$IP$2:$IP$25001,1,Input!$EQ$2:$EQ$25001)","v":2.2600925925925925},null,null,null,null,null,{"$f":"SUMIF(Input!$IP$2:$IP$25001,1,Input!$AF$2:$AF$25001)/SUMIF(Input!$IP$2:$IP$25001,1,Input!$ER$2:$ER$25001)","v":2.3681730769230769},null,null,null,null,null,6.2030533459061701E-3,null,null,null,null,null,0.10808048433048434,null,null,null,null,null,4.7821263909591988E-2,null,null,null,null,null,null,null,null,{"$f":"(SUMIF(Input!$IP$2:$IP$25001,1,Input!$CA$2:$CA$25001)/SUMIF(Input!$IP$2:$IP$25001,1,Input!$EQ$2:$EQ$25001))*12000","v":277.77777777777777},null,null,null,null,null,{"$f":"(SUMIF(Input!$IP$2:$IP$25001,1,Input!$CB$2:$CB$25001)/SUMIF(Input!$IP$2:$IP$25001,1,Input!$ER$2:$ER$25001))*12000","v":346.15384615384619},null,null,null,null,null,68.376068376068417,null,null,null,null,null,0.24615384615384631]
[null,null,null,null,null,null,null,null,null,null,null,"Diagnostics - Radiation Therapy",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUMIF(Input!$IP$2:$IP$25001,1,Input!$AG$2:$AG$25001)/SUMIF(Input!$IP$2:$IP$25001,1,Input!$EQ$2:$EQ$25001)","v":0},null,null,null,null,null,{"$f":"SUMIF(Input!$IP$2:$IP$25001,1,Input!$AH$2:$AH$25001)/SUMIF(Input!$IP$2:$IP$25001,1,Input!$ER$2:$ER$25001)","v":0},null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,"",null,null,null,null,null,null,null,null,{"$f":"(SUMIF(Input!$IP$2:$IP$25001,1,Input!$CC$2:$CC$25001)/SUMIF(Input!$IP$2:$IP$25001,1,Input!$EQ$2:$EQ$25001))*12000","v":0},null,null,null,null,null,{"$f":"(SUMIF(Input!$IP$2:$IP$25001,1,Input!$CD$2:$CD$25001)/SUMIF(Input!$IP$2:$IP$25001,1,Input!$ER$2:$ER$25001))*12000","v":0},null,null,null,null,null,0,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,"PCP Services",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUMIF(Input!$IP$2:$IP$25001,1,Input!$AI$2:$AI$25001)/SUMIF(Input!$IP$2:$IP$25001,1,Input!$EQ$2:$EQ$25001)","v":22.669259259259256},null,null,null,null,null,{"$f":"SUMIF(Input!$IP$2:$IP$25001,1,Input!$AJ$2:$AJ$25001)/SUMIF(Input!$IP$2:$IP$25001,1,Input!$ER$2:$ER$25001)","v":22.395},null,null,null,null,null,5.8660146521917832E-2,null,null,null,null,null,-0.27425925925925654,null,null,null,null,null,-1.2098289411341721E-2,null,null,null,null,null,null,null,null,{"$f":"(SUMIF(Input!$IP$2:$IP$25001,1,Input!$CE$2:$CE$25001)/SUMIF(Input!$IP$2:$IP$25001,1,Input!$EQ$2:$EQ$25001))*12000","v":3722.2222222222222},null,null,null,null,null,{"$f":"(SUMIF(Input!$IP$2:$IP$25001,1,Input!$CF$2:$CF$25001)/SUMIF(Input!$IP$2:$IP$25001,1,Input!$ER$2:$ER$25001))*12000","v":4038.4615384615386},null,null,null,null,null,316.23931623931639,null,null,null,null,null,8.4959816303099928E-2]
[null,null,null,null,null,null,null,null,null,null,null,"Specialist Services ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUMIF(Input!$IP$2:$IP$25001,1,Input!$AK$2:$AK$25001)/SUMIF(Input!$IP$2:$IP$25001,1,Input!$EQ$2:$EQ$25001)","v":14.472268518518515},null,null,null,null,null,{"$f":"SUMIF(Input!$IP$2:$IP$25001,1,Input!$AL$2:$AL$25001)/SUMIF(Input!$IP$2:$IP$25001,1,Input!$ER$2:$ER$25001)","v":20.4175},null,null,null,null,null,5.3480399268196359E-2,null,null,null,null,null,5.9452314814814855,null,null,null,null,null,0.4108016289135355,null,null,null,null,null,null,null,null,{"$f":"(SUMIF(Input!$IP$2:$IP$25001,1,Input!$CG$2:$CG$25001)/SUMIF(Input!$IP$2:$IP$25001,1,Input!$EQ$2:$EQ$25001))*12000","v":1722.2222222222222},null,null,null,null,null,{"$f":"(SUMIF(Input!$IP$2:$IP$25001,1,Input!$CH$2:$CH$25001)/SUMIF(Input!$IP$2:$IP$25001,1,Input!$ER$2:$ER$25001))*12000","v":2423.0769230769233},null,null,null,null,null,700.85470085470115,null,null,null,null,null,0.40694789081885874]
[null,null,null,null,null,null,null,null,null,null,null,"DME & Medical Supplies",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUMIF(Input!$IP$2:$IP$25001,1,Input!$IT$2:$IT$25001)/SUMIF(Input!$IP$2:$IP$25001,1,Input!$EQ$2:$EQ$25001)","v":2.399861111111111},null,null,null,null,null,{"$f":"SUMIF(Input!$IP$2:$IP$25001,1,Input!$IU$2:$IU$25001)/SUMIF(Input!$IP$2:$IP$25001,1,Input!$ER$2:$ER$25001)","v":19.485576923076923},null,null,null,null,null,5.1039374743103064E-2,null,null,null,null,null,17.085715811965812,null,null,null,null,null,7.1194602607878847,null,null,null,null,null,null,null,null,{"$f":"(SUMIF(Input!$IP$2:$IP$25001,1,Input!$IX$2:$IX$25001)/SUMIF(Input!$IP$2:$IP$25001,1,Input!$EQ$2:$EQ$25001))*12000","v":333.33333333333331},null,null,null,null,null,{"$f":"(SUMIF(Input!$IP$2:$IP$25001,1,Input!$IY$2:$IY$25001)/SUMIF(Input!$IP$2:$IP$25001,1,Input!$ER$2:$ER$25001))*12000","v":230.76923076923077},null,null,null,null,null,-102.56410256410254,null,null,null,null,null,-0.30769230769230765]
[null,null,null,null,null,null,null,null,null,null,null,"Medical Transport - Ambulance",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUMIF(Input!$IP$2:$IP$25001,1,Input!$AQ$2:$AQ$25001)/SUMIF(Input!$IP$2:$IP$25001,1,Input!$EQ$2:$EQ$25001)","v":1.6403240740740741},null,null,null,null,null,{"$f":"SUMIF(Input!$IP$2:$IP$25001,1,Input!$AR$2:$AR$25001)/SUMIF(Input!$IP$2:$IP$25001,1,Input!$ER$2:$ER$25001)","v":5.1544711538461545},null,null,null,null,null,1.3501318737558129E-2,null,null,null,null,null,3.5141470797720804,null,null,null,null,null,2.1423492682418486,null,null,null,null,null,null,null,null,{"$f":"(SUMIF(Input!$IP$2:$IP$25001,1,Input!$CM$2:$CM$25001)/SUMIF(Input!$IP$2:$IP$25001,1,Input!$EQ$2:$EQ$25001))*12000","v":166.66666666666666},null,null,null,null,null,{"$f":"(SUMIF(Input!$IP$2:$IP$25001,1,Input!$CN$2:$CN$25001)/SUMIF(Input!$IP$2:$IP$25001,1,Input!$ER$2:$ER$25001))*12000","v":346.15384615384619},null,null,null,null,null,179.48717948717953,null,null,null,null,null,1.0769230769230773]
[null,null,null,null,null,null,null,null,null,null,null,"Injectable Drugs",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUMIF(Input!$IP$2:$IP$25001,1,Input!$AS$2:$AS$25001)/SUMIF(Input!$IP$2:$IP$25001,1,Input!$EQ$2:$EQ$25001)","v":3.7037037037037035E-4},null,null,null,null,null,{"$f":"SUMIF(Input!$IP$2:$IP$25001,1,Input!$AT$2:$AT$25001)/SUMIF(Input!$IP$2:$IP$25001,1,Input!$ER$2:$ER$25001)","v":0.80576923076923079},null,null,null,null,null,2.110584556364193E-3,null,null,null,null,null,0.80539886039886044,null,null,null,null,null,2174.5769230769233,null,null,null,null,null,null,null,null,{"$f":"(SUMIF(Input!$IP$2:$IP$25001,1,Input!$CO$2:$CO$25001)/SUMIF(Input!$IP$2:$IP$25001,1,Input!$EQ$2:$EQ$25001))*12000","v":55.55555555555555},null,null,null,null,null,{"$f":"(SUMIF(Input!$IP$2:$IP$25001,1,Input!$CP$2:$CP$25001)/SUMIF(Input!$IP$2:$IP$25001,1,Input!$ER$2:$ER$25001))*12000","v":173.07692307692309},null,null,null,null,null,117.52136752136755,null,null,null,null,null,2.1153846153846163]
[null,null,null,null,null,null,null,null,null,null,null,"Home and Hospice Care",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUMIF(Input!$IP$2:$IP$25001,1,Input!$AU$2:$AU$25001)/SUMIF(Input!$IP$2:$IP$25001,1,Input!$EQ$2:$EQ$25001)","v":0},null,null,null,null,null,{"$f":"SUMIF(Input!$IP$2:$IP$25001,1,Input!$AV$2:$AV$25001)/SUMIF(Input!$IP$2:$IP$25001,1,Input!$ER$2:$ER$25001)","v":0},null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,"",null,null,null,null,null,null,null,null,{"$f":"(SUMIF(Input!$IP$2:$IP$25001,1,Input!$CQ$2:$CQ$25001)/SUMIF(Input!$IP$2:$IP$25001,1,Input!$EQ$2:$EQ$25001))*12000","v":0},null,null,null,null,null,{"$f":"(SUMIF(Input!$IP$2:$IP$25001,1,Input!$CR$2:$CR$25001)/SUMIF(Input!$IP$2:$IP$25001,1,Input!$ER$2:$ER$25001))*12000","v":0},null,null,null,null,null,0,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,"Dialysis",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUMIF(Input!$IP$2:$IP$25001,1,Input!$AW$2:$AW$25001)/SUMIF(Input!$IP$2:$IP$25001,1,Input!$EQ$2:$EQ$25001)","v":0},null,null,null,null,null,{"$f":"SUMIF(Input!$IP$2:$IP$25001,1,Input!$AX$2:$AX$25001)/SUMIF(Input!$IP$2:$IP$25001,1,Input!$ER$2:$ER$25001)","v":0},null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,"",null,null,null,null,null,null,null,null,{"$f":"(SUMIF(Input!$IP$2:$IP$25001,1,Input!$CS$2:$CS$25001)/SUMIF(Input!$IP$2:$IP$25001,1,Input!$EQ$2:$EQ$25001))*12000","v":0},null,null,null,null,null,{"$f":"(SUMIF(Input!$IP$2:$IP$25001,1,Input!$CT$2:$CT$25001)/SUMIF(Input!$IP$2:$IP$25001,1,Input!$ER$2:$ER$25001))*12000","v":0},null,null,null,null,null,0,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,"(Non CCBH) -Behavioral Health",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUMIF(Input!$IP$2:$IP$25001,1,Input!$IV$2:$IV$25001)/SUMIF(Input!$IP$2:$IP$25001,1,Input!$EQ$2:$EQ$25001)","v":0},null,null,null,null,null,{"$f":"SUMIF(Input!$IP$2:$IP$25001,1,Input!$IW$2:$IW$25001)/SUMIF(Input!$IP$2:$IP$25001,1,Input!$ER$2:$ER$25001)","v":11.296730769230768},null,null,null,null,null,2.9589992504654362E-2,null,null,null,null,null,11.296730769230768,null,null,null,null,null,"",null,null,null,null,null,null,null,null,{"$f":"(SUMIF(Input!$IP$2:$IP$25001,1,Input!$IZ$2:$IZ$25001)/SUMIF(Input!$IP$2:$IP$25001,1,Input!$EQ$2:$EQ$25001))*12000","v":0},null,null,null,null,null,{"$f":"(SUMIF(Input!$IP$2:$IP$25001,1,Input!$JA$2:$JA$25001)/SUMIF(Input!$IP$2:$IP$25001,1,Input!$ER$2:$ER$25001))*12000","v":576.92307692307691},null,null,null,null,null,576.92307692307691,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,"Catastrophic (Shock) Claims",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUMIF(Input!$IP$2:$IP$25001,1,Input!$BC$2:$BC$25001)/SUMIF(Input!$IP$2:$IP$25001,1,Input!$EQ$2:$EQ$25001)","v":0},null,null,null,null,null,{"$f":"SUMIF(Input!$IP$2:$IP$25001,1,Input!$BD$2:$BD$25001)/SUMIF(Input!$IP$2:$IP$25001,1,Input!$ER$2:$ER$25001)","v":0},null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,"",null,null,null,null,null,null,null,null,{"$f":"(SUMIF(Input!$IP$2:$IP$25001,1,Input!$CY$2:$CY$25001)/SUMIF(Input!$IP$2:$IP$25001,1,Input!$EQ$2:$EQ$25001))*12000","v":0},null,null,null,null,null,{"$f":"(SUMIF(Input!$IP$2:$IP$25001,1,Input!$CZ$2:$CZ$25001)/SUMIF(Input!$IP$2:$IP$25001,1,Input!$ER$2:$ER$25001))*12000","v":0},null,null,null,null,null,0,null,null,null,null,null,{"$f":"IFERROR(CA109/BO109,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,"Pharmacy",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"BG52","v":123.15805555555556},null,null,null,null,null,{"$f":"BQ52","v":157.83822115384615},null,null,null,null,null,0.41343215805507866,null,null,null,null,null,34.680165598290586,null,null,null,null,null,0.28159072049206441,null,null,null,null,null,null,null,null,{"$f":"(SUMIF(Input!$IP$2:$IP$25001,1,Input!$EE$2:$EE$25001)/SUMIF(Input!$IP$2:$IP$25001,1,Input!$EQ$2:$EQ$25001))*12000","v":22722.222222222223},null,null,null,null,null,{"$f":"(SUMIF(Input!$IP$2:$IP$25001,1,Input!$EF$2:$EF$25001)/SUMIF(Input!$IP$2:$IP$25001,1,Input!$ER$2:$ER$25001))*12000","v":23192.307692307691},null,null,null,null,null,{"$f":"BU110-BO110","v":470.08547008546884},null,null,null,null,null,{"$f":"IFERROR(CA110/BO110,\"\")","v":2.0688358096671002E-2}]
[null,null,null,null,null,null,null,null,null,null,null,"Total Medical",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AH88:AM109)","v":81.633194444444428},null,null,null,null,null,{"$f":"SUM(AN88:AS109)","v":223.93716346153852},null,null,null,null,null,0.5865678419449214,null,null,null,null,null,142.30396901709409,null,null,null,null,null,1.7432120595738689]
[null,null,null,null,null,null,null,null,null,null,null,"Total (Medical+Rx)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AH88:AM110)","v":204.79124999999999},null,null,null,null,null,{"$f":"SUM(AN88:AS110)","v":381.77538461538467},null,null,null,null,null,null,null,null,null,null,null,176.98413461538468,null,null,null,null,null,0.86421726814687971]
[]
[]
[]
[null,null,null,null,"Which specialists did the selected population utilize in Year 2?"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Specialty",null,null,null,null,null,null,null,null,null,null,null,null,null,"Unique Members",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Spend",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PMPM",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"% of Specialty PMPM"]
[]
[null,null,null,null,null,null,null,null,null,null,null,"ANESTHESIOLOGY",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUMIF(Input!$IP$2:$IP$25001,1,Input!$KH$2:$KH$25001)","v":2},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUMIF(Input!$IP$2:$IP$25001,1,Input!$GD$2:$GD$25001)","v":912.2},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AQ121/SUMIF(Input!$IP$2:$IP$25001,1,Input!$ER$2:$ER$25001)","v":4.3855769230769237},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"BH121/$BH$141","v":0.21479500051803227}]
[null,null,null,null,null,null,null,null,null,null,null,"ORTHO SURG",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUMIF(Input!$IP$2:$IP$25001,1,Input!$KI$2:$KI$25001)","v":2},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUMIF(Input!$IP$2:$IP$25001,1,Input!$GE$2:$GE$25001)","v":250.05},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AQ122/SUMIF(Input!$IP$2:$IP$25001,1,Input!$ER$2:$ER$25001)","v":1.2021634615384615},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"BH122/$BH$141","v":5.8879072439743434E-2}]
[null,null,null,null,null,null,null,null,null,null,null,"OBGYN",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUMIF(Input!$IP$2:$IP$25001,1,Input!$KJ$2:$KJ$25001)","v":2},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUMIF(Input!$IP$2:$IP$25001,1,Input!$GF$2:$GF$25001)","v":82.5},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AQ123/SUMIF(Input!$IP$2:$IP$25001,1,Input!$ER$2:$ER$25001)","v":0.39663461538461536},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.9426208663382655E-2]
[null,null,null,null,null,null,null,null,null,null,null,"OTOLARYNGOLOGY",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUMIF(Input!$IP$2:$IP$25001,1,Input!$KK$2:$KK$25001)","v":1},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUMIF(Input!$IP$2:$IP$25001,1,Input!$GG$2:$GG$25001)","v":10.6},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AQ124/SUMIF(Input!$IP$2:$IP$25001,1,Input!$ER$2:$ER$25001)","v":5.0961538461538461E-2},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.4959734767497715E-3]
[null,null,null,null,null,null,null,null,null,null,null,"ENDOCRINOLOGY",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUMIF(Input!$IP$2:$IP$25001,1,Input!$KL$2:$KL$25001)","v":1},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUMIF(Input!$IP$2:$IP$25001,1,Input!$GH$2:$GH$25001)","v":420.5},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AQ125/SUMIF(Input!$IP$2:$IP$25001,1,Input!$ER$2:$ER$25001)","v":2.0216346153846154},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9.9014796884271603E-2]
[null,null,null,null,null,null,null,null,null,null,null,"GASTROENTEROLOGY",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUMIF(Input!$IP$2:$IP$25001,1,Input!$KM$2:$KM$25001)","v":2},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUMIF(Input!$IP$2:$IP$25001,1,Input!$GI$2:$GI$25001)","v":565.74},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AQ126/SUMIF(Input!$IP$2:$IP$25001,1,Input!$ER$2:$ER$25001)","v":2.7199038461538461},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.13321434289966186]
[null,null,null,null,null,null,null,null,null,null,null,"CARDIOLOGY",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUMIF(Input!$IP$2:$IP$25001,1,Input!$KN$2:$KN$25001)","v":1},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUMIF(Input!$IP$2:$IP$25001,1,Input!$GJ$2:$GJ$25001)","v":20},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AQ127/SUMIF(Input!$IP$2:$IP$25001,1,Input!$ER$2:$ER$25001)","v":9.6153846153846159E-2},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4.7093839183957953E-3]
[null,null,null,null,null,null,null,null,null,null,null,"NEUROLOGY",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUMIF(Input!$IP$2:$IP$25001,1,Input!$KO$2:$KO$25001)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUMIF(Input!$IP$2:$IP$25001,1,Input!$GK$2:$GK$25001)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AQ128/SUMIF(Input!$IP$2:$IP$25001,1,Input!$ER$2:$ER$25001)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,"NEURO SURG",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUMIF(Input!$IP$2:$IP$25001,1,Input!$KP$2:$KP$25001)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUMIF(Input!$IP$2:$IP$25001,1,Input!$GL$2:$GL$25001)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AQ129/SUMIF(Input!$IP$2:$IP$25001,1,Input!$ER$2:$ER$25001)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,"ORAL MAXILLO SURG",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUMIF(Input!$IP$2:$IP$25001,1,Input!$KQ$2:$KQ$25001)","v":1},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUMIF(Input!$IP$2:$IP$25001,1,Input!$GM$2:$GM$25001)","v":857.87},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AQ130/SUMIF(Input!$IP$2:$IP$25001,1,Input!$ER$2:$ER$25001)","v":4.1243749999999997},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.20200195910371002]
[null,null,null,null,null,null,null,null,null,null,null,"HEMO ONCOLOGY",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUMIF(Input!$IP$2:$IP$25001,1,Input!$KR$2:$KR$25001)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUMIF(Input!$IP$2:$IP$25001,1,Input!$GN$2:$GN$25001)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AQ131/SUMIF(Input!$IP$2:$IP$25001,1,Input!$ER$2:$ER$25001)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,"OPHTHALMOLOGY",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUMIF(Input!$IP$2:$IP$25001,1,Input!$KS$2:$KS$25001)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUMIF(Input!$IP$2:$IP$25001,1,Input!$GO$2:$GO$25001)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AQ132/SUMIF(Input!$IP$2:$IP$25001,1,Input!$ER$2:$ER$25001)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,"ALLERGY IMMUNE",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUMIF(Input!$IP$2:$IP$25001,1,Input!$KT$2:$KT$25001)","v":2},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUMIF(Input!$IP$2:$IP$25001,1,Input!$GP$2:$GP$25001)","v":345.46},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AQ133/SUMIF(Input!$IP$2:$IP$25001,1,Input!$ER$2:$ER$25001)","v":1.6608653846153845},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8.1345188422450559E-2]
[null,null,null,null,null,null,null,null,null,null,null,"SURGERY",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUMIF(Input!$IP$2:$IP$25001,1,Input!$KU$2:$KU$25001)","v":1},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUMIF(Input!$IP$2:$IP$25001,1,Input!$GQ$2:$GQ$25001)","v":259.88},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AQ134/SUMIF(Input!$IP$2:$IP$25001,1,Input!$ER$2:$ER$25001)","v":1.249423076923077},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6.1193734635634968E-2]
[null,null,null,null,null,null,null,null,null,null,null,"PULMONOLOGY",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUMIF(Input!$IP$2:$IP$25001,1,Input!$KV$2:$KV$25001)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUMIF(Input!$IP$2:$IP$25001,1,Input!$GR$2:$GR$25001)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AQ135/SUMIF(Input!$IP$2:$IP$25001,1,Input!$ER$2:$ER$25001)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,"DERMATOLOGY",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUMIF(Input!$IP$2:$IP$25001,1,Input!$KW$2:$KW$25001)","v":4},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUMIF(Input!$IP$2:$IP$25001,1,Input!$GS$2:$GS$25001)","v":335.74},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AQ136/SUMIF(Input!$IP$2:$IP$25001,1,Input!$ER$2:$ER$25001)","v":1.6141346153846154},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7.9056427838110219E-2]
[null,null,null,null,null,null,null,null,null,null,null,"UROLOGY",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUMIF(Input!$IP$2:$IP$25001,1,Input!$KX$2:$KX$25001)","v":1},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUMIF(Input!$IP$2:$IP$25001,1,Input!$GT$2:$GT$25001)","v":40},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AQ137/SUMIF(Input!$IP$2:$IP$25001,1,Input!$ER$2:$ER$25001)","v":0.19230769230769232},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9.4187678367915906E-3]
[null,null,null,null,null,null,null,null,null,null,null,"PLASTIC SURG",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUMIF(Input!$IP$2:$IP$25001,1,Input!$KY$2:$KY$25001)","v":1},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUMIF(Input!$IP$2:$IP$25001,1,Input!$GU$2:$GU$25001)","v":146.30000000000001},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AQ138/SUMIF(Input!$IP$2:$IP$25001,1,Input!$ER$2:$ER$25001)","v":0.70336538461538467},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3.4449143363065246E-2]
[null,null,null,null,null,null,null,null,null,null,null,"NEPHROLOGY",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUMIF(Input!$IP$2:$IP$25001,1,Input!$KZ$2:$KZ$25001)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUMIF(Input!$IP$2:$IP$25001,1,Input!$GV$2:$GV$25001)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AQ139/SUMIF(Input!$IP$2:$IP$25001,1,Input!$ER$2:$ER$25001)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,"ALL OTHER SPECIALISTS",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUMIF(Input!$IP$2:$IP$25001,1,Input!$LA$2:$LA$25001)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUMIF(Input!$IP$2:$IP$25001,1,Input!$GW$2:$GW$25001)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AQ140/SUMIF(Input!$IP$2:$IP$25001,1,Input!$ER$2:$ER$25001)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,"Total",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUMIF(Input!$IP$2:$IP$25001,1,Input!$LB$2:$LB$25001)","v":11},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AQ121:BD140)","v":4246.84},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AQ141/SUMIF(Input!$IP$2:$IP$25001,1,Input!$ER$2:$ER$25001)","v":20.4175},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(BY121:CL140)","v":0.99999999999999989}]
[]
[]
[null,null,null,null,"What conditions affect the selected population?"]
[]
[]
[null,null,null,null,null,null,null,null,null,"<=== Click \"Refresh\" to Update Conditions Data"]
[]
[]
[]
[null,null,"Condition",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Prevalence",null,null,null,null,null,null,null,null,"Year 2 PMPM Spend",null,null,null,null,null,null,null,null,null,null,null,"Year 2 Total Spend"]
[]
[null,1,{"$f":"VLOOKUP(B153,Macro_Data!$AY$6:$AZ$42,2,FALSE)","v":"ASTHMA"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(B153,Macro_Data!$AY$6:$BA$42,3,FALSE)","v":16},null,null,null,{"$f":"VLOOKUP(B153,Macro_Data!$AY$6:$BD$42,6,FALSE)","v":0.33333333333333331},null,null,null,null,{"$f":"VLOOKUP(B153,Macro_Data!$AY$6:$BB$42,4,FALSE)","v":6.0638339222614839},null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(B153,Macro_Data!$AY$6:$BC$42,5,FALSE)","v":3432.13}]
[null,2,{"$f":"VLOOKUP(B154,Macro_Data!$AY$6:$AZ$42,2,FALSE)","v":"DM"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(B154,Macro_Data!$AY$6:$BA$42,3,FALSE)","v":1},null,null,null,{"$f":"VLOOKUP(B154,Macro_Data!$AY$6:$BD$42,6,FALSE)","v":2.0833333333333332E-2},null,null,null,null,{"$f":"VLOOKUP(B154,Macro_Data!$AY$6:$BB$42,4,FALSE)","v":1.088904593639576},null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(B154,Macro_Data!$AY$6:$BC$42,5,FALSE)","v":616.32000000000005}]
[null,3,{"$f":"VLOOKUP(B155,Macro_Data!$AY$6:$AZ$42,2,FALSE)","v":"SPINA BIFIDA SCI"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(B155,Macro_Data!$AY$6:$BA$42,3,FALSE)","v":0},null,null,null,{"$f":"VLOOKUP(B155,Macro_Data!$AY$6:$BD$42,6,FALSE)","v":0},null,null,null,null,{"$f":"VLOOKUP(B155,Macro_Data!$AY$6:$BB$42,4,FALSE)","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(B155,Macro_Data!$AY$6:$BC$42,5,FALSE)","v":0}]
[null,4,{"$f":"VLOOKUP(B156,Macro_Data!$AY$6:$AZ$42,2,FALSE)","v":"NEOPLASM MALIGNANT"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(B156,Macro_Data!$AY$6:$BA$42,3,FALSE)","v":0},null,null,null,{"$f":"VLOOKUP(B156,Macro_Data!$AY$6:$BD$42,6,FALSE)","v":0},null,null,null,null,{"$f":"VLOOKUP(B156,Macro_Data!$AY$6:$BB$42,4,FALSE)","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(B156,Macro_Data!$AY$6:$BC$42,5,FALSE)","v":0}]
[null,5,{"$f":"VLOOKUP(B157,Macro_Data!$AY$6:$AZ$42,2,FALSE)","v":"LUPUS CONN TISSUE DISORDERS"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(B157,Macro_Data!$AY$6:$BA$42,3,FALSE)","v":0},null,null,null,{"$f":"VLOOKUP(B157,Macro_Data!$AY$6:$BD$42,6,FALSE)","v":0},null,null,null,null,{"$f":"VLOOKUP(B157,Macro_Data!$AY$6:$BB$42,4,FALSE)","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(B157,Macro_Data!$AY$6:$BC$42,5,FALSE)","v":0}]
[null,6,{"$f":"VLOOKUP(B158,Macro_Data!$AY$6:$AZ$42,2,FALSE)","v":"CENTRAL NERV SYS DISEASE"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(B158,Macro_Data!$AY$6:$BA$42,3,FALSE)","v":1},null,null,null,{"$f":"VLOOKUP(B158,Macro_Data!$AY$6:$BD$42,6,FALSE)","v":2.0833333333333332E-2},null,null,null,null,{"$f":"VLOOKUP(B158,Macro_Data!$AY$6:$BB$42,4,FALSE)","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(B158,Macro_Data!$AY$6:$BC$42,5,FALSE)","v":0}]
[null,7,{"$f":"VLOOKUP(B159,Macro_Data!$AY$6:$AZ$42,2,FALSE)","v":"PARALYSIS"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(B159,Macro_Data!$AY$6:$BA$42,3,FALSE)","v":0},null,null,null,{"$f":"VLOOKUP(B159,Macro_Data!$AY$6:$BD$42,6,FALSE)","v":0},null,null,null,null,{"$f":"VLOOKUP(B159,Macro_Data!$AY$6:$BB$42,4,FALSE)","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(B159,Macro_Data!$AY$6:$BC$42,5,FALSE)","v":0}]
[null,8,{"$f":"VLOOKUP(B160,Macro_Data!$AY$6:$AZ$42,2,FALSE)","v":"CEREBRAL PALSY"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(B160,Macro_Data!$AY$6:$BA$42,3,FALSE)","v":1},null,null,null,{"$f":"VLOOKUP(B160,Macro_Data!$AY$6:$BD$42,6,FALSE)","v":2.0833333333333332E-2},null,null,null,null,{"$f":"VLOOKUP(B160,Macro_Data!$AY$6:$BB$42,4,FALSE)","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(B160,Macro_Data!$AY$6:$BC$42,5,FALSE)","v":0}]
[null,9,{"$f":"VLOOKUP(B161,Macro_Data!$AY$6:$AZ$42,2,FALSE)","v":"INFLAMMATORY BOWEL DISEASE"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(B161,Macro_Data!$AY$6:$BA$42,3,FALSE)","v":0},null,null,null,{"$f":"VLOOKUP(B161,Macro_Data!$AY$6:$BD$42,6,FALSE)","v":0},null,null,null,null,{"$f":"VLOOKUP(B161,Macro_Data!$AY$6:$BB$42,4,FALSE)","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(B161,Macro_Data!$AY$6:$BC$42,5,FALSE)","v":0}]
[null,10,{"$f":"VLOOKUP(B162,Macro_Data!$AY$6:$AZ$42,2,FALSE)","v":"CEREBRO VASCULAR DISEASE"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(B162,Macro_Data!$AY$6:$BA$42,3,FALSE)","v":0},null,null,null,{"$f":"VLOOKUP(B162,Macro_Data!$AY$6:$BD$42,6,FALSE)","v":0},null,null,null,null,{"$f":"VLOOKUP(B162,Macro_Data!$AY$6:$BB$42,4,FALSE)","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(B162,Macro_Data!$AY$6:$BC$42,5,FALSE)","v":0}]
[null,11,{"$f":"VLOOKUP(B163,Macro_Data!$AY$6:$AZ$42,2,FALSE)","v":"MORBID OBESITY"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(B163,Macro_Data!$AY$6:$BA$42,3,FALSE)","v":0},null,null,null,{"$f":"VLOOKUP(B163,Macro_Data!$AY$6:$BD$42,6,FALSE)","v":0},null,null,null,null,{"$f":"VLOOKUP(B163,Macro_Data!$AY$6:$BB$42,4,FALSE)","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(B163,Macro_Data!$AY$6:$BC$42,5,FALSE)","v":0}]
[null,12,{"$f":"VLOOKUP(B164,Macro_Data!$AY$6:$AZ$42,2,FALSE)","v":"CHF"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(B164,Macro_Data!$AY$6:$BA$42,3,FALSE)","v":0},null,null,null,{"$f":"VLOOKUP(B164,Macro_Data!$AY$6:$BD$42,6,FALSE)","v":0},null,null,null,null,{"$f":"VLOOKUP(B164,Macro_Data!$AY$6:$BB$42,4,FALSE)","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(B164,Macro_Data!$AY$6:$BC$42,5,FALSE)","v":0}]
[null,13,{"$f":"VLOOKUP(B165,Macro_Data!$AY$6:$AZ$42,2,FALSE)","v":"OSTEOPOROSIS"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(B165,Macro_Data!$AY$6:$BA$42,3,FALSE)","v":0},null,null,null,{"$f":"VLOOKUP(B165,Macro_Data!$AY$6:$BD$42,6,FALSE)","v":0},null,null,null,null,{"$f":"VLOOKUP(B165,Macro_Data!$AY$6:$BB$42,4,FALSE)","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(B165,Macro_Data!$AY$6:$BC$42,5,FALSE)","v":0}]
[null,14,{"$f":"VLOOKUP(B166,Macro_Data!$AY$6:$AZ$42,2,FALSE)","v":"CHRONIC HEPATITIS"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(B166,Macro_Data!$AY$6:$BA$42,3,FALSE)","v":0},null,null,null,{"$f":"VLOOKUP(B166,Macro_Data!$AY$6:$BD$42,6,FALSE)","v":0},null,null,null,null,{"$f":"VLOOKUP(B166,Macro_Data!$AY$6:$BB$42,4,FALSE)","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(B166,Macro_Data!$AY$6:$BC$42,5,FALSE)","v":0}]
[null,15,{"$f":"VLOOKUP(B167,Macro_Data!$AY$6:$AZ$42,2,FALSE)","v":"RENAL DISEASE"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(B167,Macro_Data!$AY$6:$BA$42,3,FALSE)","v":0},null,null,null,{"$f":"VLOOKUP(B167,Macro_Data!$AY$6:$BD$42,6,FALSE)","v":0},null,null,null,null,{"$f":"VLOOKUP(B167,Macro_Data!$AY$6:$BB$42,4,FALSE)","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(B167,Macro_Data!$AY$6:$BC$42,5,FALSE)","v":0}]
[null,16,{"$f":"VLOOKUP(B168,Macro_Data!$AY$6:$AZ$42,2,FALSE)","v":"COAGULATION DEFECTS"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(B168,Macro_Data!$AY$6:$BA$42,3,FALSE)","v":0},null,null,null,{"$f":"VLOOKUP(B168,Macro_Data!$AY$6:$BD$42,6,FALSE)","v":0},null,null,null,null,{"$f":"VLOOKUP(B168,Macro_Data!$AY$6:$BB$42,4,FALSE)","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(B168,Macro_Data!$AY$6:$BC$42,5,FALSE)","v":0}]
[null,17,{"$f":"VLOOKUP(B169,Macro_Data!$AY$6:$AZ$42,2,FALSE)","v":"ATRIAL FIBRILLATION"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(B169,Macro_Data!$AY$6:$BA$42,3,FALSE)","v":0},null,null,null,{"$f":"VLOOKUP(B169,Macro_Data!$AY$6:$BD$42,6,FALSE)","v":0},null,null,null,null,{"$f":"VLOOKUP(B169,Macro_Data!$AY$6:$BB$42,4,FALSE)","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(B169,Macro_Data!$AY$6:$BC$42,5,FALSE)","v":0}]
[null,18,{"$f":"VLOOKUP(B170,Macro_Data!$AY$6:$AZ$42,2,FALSE)","v":"COPD"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(B170,Macro_Data!$AY$6:$BA$42,3,FALSE)","v":0},null,null,null,{"$f":"VLOOKUP(B170,Macro_Data!$AY$6:$BD$42,6,FALSE)","v":0},null,null,null,null,{"$f":"VLOOKUP(B170,Macro_Data!$AY$6:$BB$42,4,FALSE)","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(B170,Macro_Data!$AY$6:$BC$42,5,FALSE)","v":0}]
[null,19,{"$f":"VLOOKUP(B171,Macro_Data!$AY$6:$AZ$42,2,FALSE)","v":"LIVER DISEASE"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(B171,Macro_Data!$AY$6:$BA$42,3,FALSE)","v":0},null,null,null,{"$f":"VLOOKUP(B171,Macro_Data!$AY$6:$BD$42,6,FALSE)","v":0},null,null,null,null,{"$f":"VLOOKUP(B171,Macro_Data!$AY$6:$BB$42,4,FALSE)","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(B171,Macro_Data!$AY$6:$BC$42,5,FALSE)","v":0}]
[null,20,{"$f":"VLOOKUP(B172,Macro_Data!$AY$6:$AZ$42,2,FALSE)","v":"CYSTIC FIBROSIS"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(B172,Macro_Data!$AY$6:$BA$42,3,FALSE)","v":0},null,null,null,{"$f":"VLOOKUP(B172,Macro_Data!$AY$6:$BD$42,6,FALSE)","v":0},null,null,null,null,{"$f":"VLOOKUP(B172,Macro_Data!$AY$6:$BB$42,4,FALSE)","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(B172,Macro_Data!$AY$6:$BC$42,5,FALSE)","v":0}]
[null,21,{"$f":"VLOOKUP(B173,Macro_Data!$AY$6:$AZ$42,2,FALSE)","v":"MIGRAINE"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(B173,Macro_Data!$AY$6:$BA$42,3,FALSE)","v":1},null,null,null,{"$f":"VLOOKUP(B173,Macro_Data!$AY$6:$BD$42,6,FALSE)","v":2.0833333333333332E-2},null,null,null,null,{"$f":"VLOOKUP(B173,Macro_Data!$AY$6:$BB$42,4,FALSE)","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(B173,Macro_Data!$AY$6:$BC$42,5,FALSE)","v":0}]
[null,22,{"$f":"VLOOKUP(B174,Macro_Data!$AY$6:$AZ$42,2,FALSE)","v":"MULTIPLE SCLEROSIS"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(B174,Macro_Data!$AY$6:$BA$42,3,FALSE)","v":0},null,null,null,{"$f":"VLOOKUP(B174,Macro_Data!$AY$6:$BD$42,6,FALSE)","v":0},null,null,null,null,{"$f":"VLOOKUP(B174,Macro_Data!$AY$6:$BB$42,4,FALSE)","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(B174,Macro_Data!$AY$6:$BC$42,5,FALSE)","v":0}]
[null,23,{"$f":"VLOOKUP(B175,Macro_Data!$AY$6:$AZ$42,2,FALSE)","v":"CAD"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(B175,Macro_Data!$AY$6:$BA$42,3,FALSE)","v":0},null,null,null,{"$f":"VLOOKUP(B175,Macro_Data!$AY$6:$BD$42,6,FALSE)","v":0},null,null,null,null,{"$f":"VLOOKUP(B175,Macro_Data!$AY$6:$BB$42,4,FALSE)","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(B175,Macro_Data!$AY$6:$BC$42,5,FALSE)","v":0}]
[null,24,{"$f":"VLOOKUP(B176,Macro_Data!$AY$6:$AZ$42,2,FALSE)","v":"MUSCULAR DYSTROPHY"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(B176,Macro_Data!$AY$6:$BA$42,3,FALSE)","v":0},null,null,null,{"$f":"VLOOKUP(B176,Macro_Data!$AY$6:$BD$42,6,FALSE)","v":0},null,null,null,null,{"$f":"VLOOKUP(B176,Macro_Data!$AY$6:$BB$42,4,FALSE)","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(B176,Macro_Data!$AY$6:$BC$42,5,FALSE)","v":0}]
[null,25,{"$f":"VLOOKUP(B177,Macro_Data!$AY$6:$AZ$42,2,FALSE)","v":"MYASTHENIA GRAVIS"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(B177,Macro_Data!$AY$6:$BA$42,3,FALSE)","v":0},null,null,null,{"$f":"VLOOKUP(B177,Macro_Data!$AY$6:$BD$42,6,FALSE)","v":0},null,null,null,null,{"$f":"VLOOKUP(B177,Macro_Data!$AY$6:$BB$42,4,FALSE)","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(B177,Macro_Data!$AY$6:$BC$42,5,FALSE)","v":0}]
[null,26,{"$f":"VLOOKUP(B178,Macro_Data!$AY$6:$AZ$42,2,FALSE)","v":"EPILEPSY"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(B178,Macro_Data!$AY$6:$BA$42,3,FALSE)","v":1},null,null,null,{"$f":"VLOOKUP(B178,Macro_Data!$AY$6:$BD$42,6,FALSE)","v":2.0833333333333332E-2},null,null,null,null,{"$f":"VLOOKUP(B178,Macro_Data!$AY$6:$BB$42,4,FALSE)","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(B178,Macro_Data!$AY$6:$BC$42,5,FALSE)","v":0}]
[null,27,{"$f":"VLOOKUP(B179,Macro_Data!$AY$6:$AZ$42,2,FALSE)","v":"OSTEOARTHRITIS"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(B179,Macro_Data!$AY$6:$BA$42,3,FALSE)","v":0},null,null,null,{"$f":"VLOOKUP(B179,Macro_Data!$AY$6:$BD$42,6,FALSE)","v":0},null,null,null,null,{"$f":"VLOOKUP(B179,Macro_Data!$AY$6:$BB$42,4,FALSE)","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(B179,Macro_Data!$AY$6:$BC$42,5,FALSE)","v":0}]
[null,28,{"$f":"VLOOKUP(B180,Macro_Data!$AY$6:$AZ$42,2,FALSE)","v":"ESRD"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(B180,Macro_Data!$AY$6:$BA$42,3,FALSE)","v":0},null,null,null,{"$f":"VLOOKUP(B180,Macro_Data!$AY$6:$BD$42,6,FALSE)","v":0},null,null,null,null,{"$f":"VLOOKUP(B180,Macro_Data!$AY$6:$BB$42,4,FALSE)","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(B180,Macro_Data!$AY$6:$BC$42,5,FALSE)","v":0}]
[null,29,{"$f":"VLOOKUP(B181,Macro_Data!$AY$6:$AZ$42,2,FALSE)","v":"PANCREATITIS CHRONIC"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(B181,Macro_Data!$AY$6:$BA$42,3,FALSE)","v":0},null,null,null,{"$f":"VLOOKUP(B181,Macro_Data!$AY$6:$BD$42,6,FALSE)","v":0},null,null,null,null,{"$f":"VLOOKUP(B181,Macro_Data!$AY$6:$BB$42,4,FALSE)","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(B181,Macro_Data!$AY$6:$BC$42,5,FALSE)","v":0}]
[null,30,{"$f":"VLOOKUP(B182,Macro_Data!$AY$6:$AZ$42,2,FALSE)","v":"HEMATOLOGICAL SICKLE CELL"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(B182,Macro_Data!$AY$6:$BA$42,3,FALSE)","v":0},null,null,null,{"$f":"VLOOKUP(B182,Macro_Data!$AY$6:$BD$42,6,FALSE)","v":0},null,null,null,null,{"$f":"VLOOKUP(B182,Macro_Data!$AY$6:$BB$42,4,FALSE)","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(B182,Macro_Data!$AY$6:$BC$42,5,FALSE)","v":0}]
[null,31,{"$f":"VLOOKUP(B183,Macro_Data!$AY$6:$AZ$42,2,FALSE)","v":"PARKINSONS DISEASE"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(B183,Macro_Data!$AY$6:$BA$42,3,FALSE)","v":0},null,null,null,{"$f":"VLOOKUP(B183,Macro_Data!$AY$6:$BD$42,6,FALSE)","v":0},null,null,null,null,{"$f":"VLOOKUP(B183,Macro_Data!$AY$6:$BB$42,4,FALSE)","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(B183,Macro_Data!$AY$6:$BC$42,5,FALSE)","v":0}]
[null,32,{"$f":"VLOOKUP(B184,Macro_Data!$AY$6:$AZ$42,2,FALSE)","v":"HIV"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(B184,Macro_Data!$AY$6:$BA$42,3,FALSE)","v":0},null,null,null,{"$f":"VLOOKUP(B184,Macro_Data!$AY$6:$BD$42,6,FALSE)","v":0},null,null,null,null,{"$f":"VLOOKUP(B184,Macro_Data!$AY$6:$BB$42,4,FALSE)","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(B184,Macro_Data!$AY$6:$BC$42,5,FALSE)","v":0}]
[null,33,{"$f":"VLOOKUP(B185,Macro_Data!$AY$6:$AZ$42,2,FALSE)","v":"RHEUMA ARTHRITIS"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(B185,Macro_Data!$AY$6:$BA$42,3,FALSE)","v":1},null,null,null,{"$f":"VLOOKUP(B185,Macro_Data!$AY$6:$BD$42,6,FALSE)","v":2.0833333333333332E-2},null,null,null,null,{"$f":"VLOOKUP(B185,Macro_Data!$AY$6:$BB$42,4,FALSE)","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(B185,Macro_Data!$AY$6:$BC$42,5,FALSE)","v":0}]
[null,34,{"$f":"VLOOKUP(B186,Macro_Data!$AY$6:$AZ$42,2,FALSE)","v":"HYPERLIPIDEMIA"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(B186,Macro_Data!$AY$6:$BA$42,3,FALSE)","v":0},null,null,null,{"$f":"VLOOKUP(B186,Macro_Data!$AY$6:$BD$42,6,FALSE)","v":0},null,null,null,null,{"$f":"VLOOKUP(B186,Macro_Data!$AY$6:$BB$42,4,FALSE)","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(B186,Macro_Data!$AY$6:$BC$42,5,FALSE)","v":0}]
[null,35,{"$f":"VLOOKUP(B187,Macro_Data!$AY$6:$AZ$42,2,FALSE)","v":"TRANSPLANT"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(B187,Macro_Data!$AY$6:$BA$42,3,FALSE)","v":0},null,null,null,{"$f":"VLOOKUP(B187,Macro_Data!$AY$6:$BD$42,6,FALSE)","v":0},null,null,null,null,{"$f":"VLOOKUP(B187,Macro_Data!$AY$6:$BB$42,4,FALSE)","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(B187,Macro_Data!$AY$6:$BC$42,5,FALSE)","v":0}]
[null,36,{"$f":"VLOOKUP(B188,Macro_Data!$AY$6:$AZ$42,2,FALSE)","v":"HYPERTENSION"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(B188,Macro_Data!$AY$6:$BA$42,3,FALSE)","v":1},null,null,null,{"$f":"VLOOKUP(B188,Macro_Data!$AY$6:$BD$42,6,FALSE)","v":2.0833333333333332E-2},null,null,null,null,{"$f":"VLOOKUP(B188,Macro_Data!$AY$6:$BB$42,4,FALSE)","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(B188,Macro_Data!$AY$6:$BC$42,5,FALSE)","v":0}]
[null,37,{"$f":"VLOOKUP(B189,Macro_Data!$AY$6:$AZ$42,2,FALSE)","v":"IMMUNE DEFICIENCY"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(B189,Macro_Data!$AY$6:$BA$42,3,FALSE)","v":0},null,null,null,{"$f":"VLOOKUP(B189,Macro_Data!$AY$6:$BD$42,6,FALSE)","v":0},null,null,null,null,{"$f":"VLOOKUP(B189,Macro_Data!$AY$6:$BB$42,4,FALSE)","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(B189,Macro_Data!$AY$6:$BC$42,5,FALSE)","v":0}]

{"sheet":"Update Preparations","index":1,"n_rows":10,"n_cols":1,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["RWJF Population Model -- Preparing the Tool for Data Updates"]
["See the separate Usage Instructions document for comprehensive list of update preparations."]
[]
["› Before you begin making any changes to this tool, be sure to save a new copy."]
["› Be sure to prepare your data so that it is in the same order as the existing columns on the Inputs tab."]
["› Clear the existing data by clicking the Clear Input Tab button to the right"]
["› Paste your data as values into the Input tab"]
["› Modify the formula in column IS and associated drop down menu only if necessary -- see page 3 of the Instructions for more detail"]
["› Update the RWJF Population Model tab to reflect your specific data set, time periods, etc."]
["› Protect and/or hide all worksheets excep the RWJF Population Model worksheet"]

{"sheet":"Data Dictionary","index":2,"n_rows":347,"n_cols":3,"rows_kept":347,"cut":false,"hidden":false,"merged":[[151,0,151,4]]}
["RWJF Population Model -- Data Dictionary"]
[]
["Field Name","Data Type","Definition"]
["UNIQUE_ID","text","unique member identifier"]
["BIRTH_DATE","date","Member date of birth"]
["AGE","number (0 decimals)","Member age"]
["GENDER_CODE","text","Member gender"]
["LOB","text","Member line of business (Medicaid, Medicare, etc.)"]
["COUNTY","text","Member county of residence"]
["MEDICAL_HOME_SITE_ID","text","Medical home (or primary care physician) ID associated with the member"]
["GroupA_IND","number (0 decimals)","Flag for members in \"Group A\" (1 = yes, 0 = no)"]
["MED_SURG_PGA_2010","accounting","All Inpatient medical/surgical (including ancillary) - total $ paid by the health plan in 2010"]
["MED_SURG_PGA_2011","accounting","All Inpatient medical/surgical (including ancillary) - total $ paid by the health plan in 2011"]
["REHAB_PGA_2010","accounting","All Inpatient facility rehabilitation services (including ancillary) - total $ paid by the health plan in 2010"]
["REHAB_PGA_2011","accounting","All Inpatient facility rehabilitation services (including ancillary) - total $ paid by the health plan in 2011"]
["SNF_PGA_2010","accounting","All Inpatient facility skilled nursing services (including ancillary) - total $ paid by the health plan in 2010"]
["SNF_PGA_2011","accounting","All Inpatient facility skilled nursing services (including ancillary) - total $ paid by the health plan in 2011"]
["OTHER_IP_PGA_2010","accounting","Other inpatient services, including pregnancy/newborn/NICU services (including ancillary) - total $ paid by the health plan in 2010"]
["OTHER_IP_PGA_2011","accounting","Other inpatient services, including pregnancy/newborn/NICU services (including ancillary) - total $ paid by the health plan in 2011"]
["OBS_PGA_2010","accounting","All facility outpatient observations services - total $ paid by the health plan in 2010"]
["OBS_PGA_2011","accounting","All facility observations services - total $ paid by the health plan in 2011"]
["ER_PGA_2010","accounting","Facility and professional emergency room services - total $ paid by the health plan in 2010"]
["ER_PGA_2011","accounting","Facility and professional emergency room services  - total $ paid by the health plan in 2011"]
["OP_SURG_PGA_2010","accounting","All outpatient facility services provided in the surgery setting (including ancillary) and/or at ambulatory surgical centers - total $ paid by the health plan in 2010"]
["OP_SURG_PGA_2011","accounting","All outpatient facility services provided in the surgery setting (including ancillary) and/or at ambulatory surgical centers - total $ paid by the health plan in 2011"]
["OP_FAC_OTHER_PGA_2010","accounting","Other outpatient facility services (including services at urgent care, retail and other clinics) - total $ paid by the health plan in 2010"]
["OP_FAC_OTHER_PGA_2011","accounting","Other outpatient facility services (including services at urgent care, retail and other clinics) - total $ paid by the health plan in 2011"]
["THERAPY_PGA_2010","accounting","All facility and professional services for physical, occupational, speech and other therapy  - total $ paid by the health plan in 2010"]
["THERAPY_PGA_2011","accounting","All facility and professional services for physical, occupational, speech and other therapy  - total $ paid by the health plan in 2011"]
["LAB_PGA_2010","accounting","All facility and professional diagnostic lab and pathology services  - total $ paid by the health plan in 2010"]
["LAB_PGA_2011","accounting","All facility and professional diagnostic lab and pathology services - total $ paid by the health plan in 2011"]
["HIGH_TECH_PGA_2010","accounting","All facility and professional high rech radiology services (MRI,CT, PET, and advanced cardiac imaging) - total $ paid by the health plan in 2010"]
["HIGH_TECH_PGA_2011","accounting","All facility and professional high rech radiology services (MRI,CT, PET, and advanced cardiac imaging) - total $ paid by the health plan in 2011"]
["LOW_TECH_PGA_2010","accounting","All facility and professional low tech radiology services (not otherwise specified as high tech or radiation therapy) - total $ paid by the health plan in 2010"]
["LOW_TECH_PGA_2011","accounting","All facility and professional low tech radiology services (not otherwise specified as high tech or radiation therapy) - total $ paid by the health plan in 2011"]
["RADIATION_PGA_2010","accounting","All facility and professional radiation therapy services.   Does not include services performed in Inpatient, ER, Urgent Care, Retail clinic, or Amb Surg - total $ paid by the health plan in 2010"]
["RADIATION_PGA_2011","accounting","All facility and professional radiation therapy services.   Does not include services performed in Inpatient, ER, Urgent Care, Retail clinic, or Amb Surg - total $ paid by the health plan in 2011"]
["PCP_PGA_2010","accounting","All Professional services by PCP with Internal medicine speciality (excluding services desgnated as well services) - total $ paid by the health plan in 2010"]
["PCP_PGA_2011","accounting","All Professional services by PCP with Internal medicine speciality (excluding services desgnated as well services) - total $ paid by the health plan in 2011"]
["SPECIALIST_PGA_2010","accounting","All specialist services (excludes services with a behavioral Health Dx, therapy services, Diagnostic services, Drug admin services, and medical supply-related services) - total $ paid by the health plan in 2010"]
["SPECIALIST_PGA_2011","accounting","All specialist services (excludes services with a behavioral Health Dx, therapy services, Diagnostic services, Drug admin services, and medical supply-related services) - total $ paid by the health plan in 2011"]
["DME_PGA_2010","accounting","Durable medical equipment  - total $ paid by the health plan in 2010"]
["DME_PGA_2011","accounting","Durable medical equipment - total $ paid by the health plan in 2011"]
["MED_SUPPLY_PGA_2010","accounting","Medical supplies - total $ paid by the health plan in 2010"]
["MED_SUPPLY_PGA_2011","accounting","Medical supplies - total $ paid by the health plan in 2011"]
["MED_TRANSPORT_PGA_2010","accounting","Medical transportation  - total $ paid by the health plan in 2010"]
["MED_TRANSPORT_PGA_2011","accounting","Medical transportation - total $ paid by the health plan in 2011"]
["INJECTABLE_PGA_2010","accounting","Injectable drugs - total $ paid by the health plan in 2010"]
["INJECTABLE_PGA_2011","accounting","Injectable drugs - total $ paid by the health plan in 2011"]
["HOME_HOSP_PGA_2010","accounting","In-home and hospice services - total $ paid by the health plan in 2010"]
["HOME_HOSP_PGA_2011","accounting","In-home and hospice services - total $ paid by the health plan in 2011"]
["DIALYSIS_PGA_2010","accounting","Dialysis (Excludes services provided in Inpatient, ER, Urgent Care, Retail Clinic, and Amb surg) - total $ paid by the health plan in 2010"]
["DIALYSIS_PGA_2011","accounting","Dialysis (Excludes services provided in Inpatient, ER, Urgent Care, Retail Clinic, and Amb surg) - total $ paid by the health plan in 2011"]
["BH_IP_PGA_2010","accounting","All Inpatient facility services for Mental Health diagnoses, chemical dependency rehab/detox (including ancillary services)  - total $ paid by the health plan in 2010 -- the majority of behavioral health claims are carved out and captured in TOTAL_BH_2010 -- all 2010 inpatient behavioral health costs to be reflected in the model should be included here"]
["BH_IP_PGA_2011","accounting","All Inpatient facility services for Mental Health diagnoses, chemical dependency rehab/detox (including ancillary services)  - total $ paid by the health plan in 2011 -- the majority of behavioral health claims are carved out and captured in TOTAL_BH_2011 -- all 2011 inpatient behavioral health costs to be reflected in the model should be included here"]
["BH_OP_PGA_2010","accounting","All outpatient facility and professional services for mental health/drug and alcohol/psychiatric services - total $ paid by the health plan in 2010 -- the majority of behavioral health claims are carved out and captured in TOTAL_BH_2010 -- all 2010 inpatient behavioral health costs to be reflected in the model should be included here"]
["BH_OP_PGA_2011","accounting","All outpatient facility and professional services for mental health/drug and alcohol/psychiatric services - total $ paid by the health plan in 2011 -- the majority of behavioral health claims are carved out and captured in TOTAL_BH_2011 -- all 2011 inpatient behavioral health costs to be reflected in the model should be included here"]
["SHOCK_PGA_2010","accounting","Shock claims - total $ paid by the health plan in 2010"]
["SHOCK_PGA_2011","accounting","Shock claims - total $ paid by the health plan in 2011"]
["MED_SURG_ADMITS_2010","number (0 decimals)","# of medical/surgical admissions in 2010"]
["MED_SURG_ADMITS_2011","number (0 decimals)","# of medical/surgical admissions in 2011"]
["REHAB_ADMITS_2010","number (0 decimals)","# of rehabilitation admissions in 2010"]
["REHAB_ADMITS_2011","number (0 decimals)","# of rehabilitation admissions in 2011"]
["SNF_ADMITS_2010","number (0 decimals)","# of skilled nursing facility admissions in 2010"]
["SNF_ADMITS_2011","number (0 decimals)","# of skilled nursing facility admissions in 2011"]
["OTHER_IP_ADMITS_2010","number (0 decimals)","# of other inpatient (including pregnancy/newborn/NICU services) admissions in 2010"]
["OTHER_IP_ADMITS_2011","number (0 decimals)","# of other inpatient (including pregnancy/newborn/NICU services) admissions in 2011"]
["OBS_CLAIMS_2010","number (0 decimals)","# of outpatient observations claims in 2010"]
["OBS_CLAIMS_2011","number (0 decimals)","# of outpatient observations claims in 2011"]
["ER_CLAIMS_2010","number (0 decimals)","# of claims in an emergency room setting in 2010"]
["ER_CLAIMS_2011","number (0 decimals)","# of claims in an emergency room setting in 2011"]
["OP_SURG_CLAIMS_2010","number (0 decimals)","# of outpatient surgical claims (in surgery setting or at ambulatory surgical centers) in 2010"]
["OP_SURG_CLAIMS_2011","number (0 decimals)","# of outpatient surgical claims (in surgery setting or at ambulatory surgical centers) in 2011"]
["OP_FAC_OTHER_CLAIMS_2010","number (0 decimals)","# of other outpatient facility claims (including urgent care, retail and other clinics) in 2010"]
["OP_FAC_OTHER_CLAIMS_2011","number (0 decimals)","# of other outpatient facility claims (including urgent care, retail and other clinics) in 2011"]
["THERAPY_CLAIMS_2010","number (0 decimals)","# of Physical, occupational, speech and other therapy claims in 2010"]
["THERAPY_CLAIMS_2011","number (0 decimals)","# of Physical, occupational, speech and other therapy claims in 2011"]
["LAB_CLAIMS_2010","number (0 decimals)","# of facility lab and pathology claims in 2010"]
["LAB_CLAIMS_2011","number (0 decimals)","# of facility lab and pathology claims in 2011"]
["HIGH_TECH_CLAIMS_2010","number (0 decimals)","# of high tech radiology (MRI,CT, PET, and advanced cardiac imaging) claims in 2010"]
["HIGH_TECH_CLAIMS_2011","number (0 decimals)","# of high tech radiology (MRI,CT, PET, and advanced cardiac imaging) claims in 2011"]
["LOW_TECH_CLAIMS_2010","number (0 decimals)","# of low tech radiology (not otherwise specified as high tech or radiation therapy) claims in 2010"]
["LOW_TECH_CLAIMS_2011","number (0 decimals)","# of low tech radiology (not otherwise specified as high tech or radiation therapy) claims in 2011"]
["RADIATION_CLAIMS_2010","number (0 decimals)","# of radiation therapy claims in 2010. Does not include services performed in Inpatient, ER, Urgent Care, Retail clinic, or Amb Surg."]
["RADIATION_CLAIMS_2011","number (0 decimals)","# of radiation therapy claims in 2011. Does not include services performed in Inpatient, ER, Urgent Care, Retail clinic, or Amb Surg."]
["PCP_CLAIMS_2010","number (0 decimals)","# of PCP with Internal medicine speciality claims in 2010 (excluding services desgnated as well services) "]
["PCP_CLAIMS_2011","number (0 decimals)","# of primary care claims in 2011 (excluding services desgnated as well services) "]
["SPECIALIST_CLAIMS_2010","number (0 decimals)","# of specialist claims in 2010. Excludes services with a behavioral Health Dx, therapy services, Diagnostic services, Drug admin services, and medical supply-related services"]
["SPECIALIST_CLAIMS_2011","number (0 decimals)","# of specialist claims in 2011. Excludes services with a behavioral Health Dx, therapy services, Diagnostic services, Drug admin services, and medical supply-related services"]
["DME_CLAIMS_2010","number (0 decimals)","# of durable medical equipment claims in 2010"]
["DME_CLAIMS_2011","number (0 decimals)","# of durable medical equipment claims in 2011"]
["MED_SUPPLY_CLAIMS_2010","number (0 decimals)","# of medical supply claims in 2010"]
["MED_SUPPLY_CLAIMS_2011","number (0 decimals)","# of medical supply claims in 2011"]
["MED_TRANSPORT_CLAIMS_2010","number (0 decimals)","# of medical transportation claims in 2010"]
["MED_TRANSPORT_CLAIMS_2011","number (0 decimals)","# of medical transportation claims in 2011"]
["INJECTABLE_CLAIMS_2010","number (0 decimals)","# of injectable drug claims in 2010"]
["INJECTABLE_CLAIMS_2011","number (0 decimals)","# of injectable drug claims in 2011"]
["HOME_HOSP_CLAIMS_2010","number (0 decimals)","# of in-home and hospice claims in 2010"]
["HOME_HOSP_CLAIMS_2011","number (0 decimals)","# of in-home and hospice claims in 2011"]
["DIALYSIS_CLAIMS_2010","number (0 decimals)","# of dialysis claims in 2010. Excludes services provided in Inpatient, ER, Urgent Care, Retail Clinic, and Amb surg"]
["DIALYSIS_CLAIMS_2011","number (0 decimals)","# of dialysis claims in 2011. Excludes services provided in Inpatient, ER, Urgent Care, Retail Clinic, and Amb surg"]
["BH_IP_ADMITS_2010","number (0 decimals)","# of inpatient behavioral health admits (mental health diagnoses, chemical dependency rehab/detox) in 2010"]
["BH_IP_ADMITS_2011","number (0 decimals)","# of inpatient behavioral health admits (mental health diagnoses, chemical dependency rehab/detox) in 2011"]
["BH_OP_CLAIMS_2010","number (0 decimals)","# of outpatient behavioral health claims (mental health/drug and alcohol/psychiatric services)  in 2010"]
["BH_OP_CLAIMS_2011","number (0 decimals)","# of outpatient behavioral health claims (mental health/drug and alcohol/psychiatric services) in 2011"]
["SHOCK_CLAIMS_2010","number (0 decimals)","# of shock claims in 2010"]
["SHOCK_CLAIMS_2011","number (0 decimals)","# of shock claims in 2011"]
["PAID_201001","accounting","Total $ paid by the health plan in January 2010"]
["PAID_201002","accounting","Total $ paid by the health plan in February 2010"]
["PAID_201003","accounting","Total $ paid by the health plan in March 2010"]
["PAID_201004","accounting","Total $ paid by the health plan in April 2010"]
["PAID_201005","accounting","Total $ paid by the health plan in May 2010"]
["PAID_201006","accounting","Total $ paid by the health plan in June 2010"]
["PAID_201007","accounting","Total $ paid by the health plan in July 2010"]
["PAID_201008","accounting","Total $ paid by the health plan in August 2010"]
["PAID_201009","accounting","Total $ paid by the health plan in September 2010"]
["PAID_201010","accounting","Total $ paid by the health plan in October 2010"]
["PAID_201011","accounting","Total $ paid by the health plan in November 2010"]
["PAID_201012","accounting","Total $ paid by the health plan in December 2010"]
["PAID_201101","accounting","Total $ paid by the health plan in January 2011"]
["PAID_201102","accounting","Total $ paid by the health plan in February 2011"]
["PAID_201103","accounting","Total $ paid by the health plan in March 2011"]
["PAID_201104","accounting","Total $ paid by the health plan in April 2011"]
["PAID_201105","accounting","Total $ paid by the health plan in May 2011"]
["PAID_201106","accounting","Total $ paid by the health plan in June 2011"]
["PAID_201107","accounting","Total $ paid by the health plan in July 2011"]
["PAID_201108","accounting","Total $ paid by the health plan in August 2011"]
["PAID_201109","accounting","Total $ paid by the health plan in September 2011"]
["PAID_201110","accounting","Total $ paid by the health plan in October 2011"]
["PAID_201111","accounting","Total $ paid by the health plan in November 2011"]
["PAID_201112","accounting","Total $ paid by the health plan in December 2011"]
["TOTAL_MED_2010","accounting","Total $ paid by the health plan on medical (non-Rx) services in 2010 (sum of all 12 PAID_2010XX fields)"]
["TOTAL_MED_2011","accounting","Total $ paid by the health plan on medical (non-Rx) services in 2011 (sum of all 12 PAID_2011XX fields)"]
["MED_PMPM_2010","accounting","Cost / total $ paid by the health plan on medical (non-Rx) services per month in 2010"]
["MED_PMPM_2011","accounting","Cost / total $ paid by the health plan on medical (non-Rx) services per month in 2011"]
["TOTAL_RX_2010","accounting","Total $ paid by the health plan on prescription drugs in 2010"]
["TOTAL_RX_2011","accounting","Total $ paid by the health plan on prescription drugs in 2011"]
["RX_SCRIPTS_2010","number","# of prescriptions in 2010"]
["RX_SCRIPTS_2011","number","# of prescriptions in 2011"]
["TOTAL_PAID_2010","accounting","Total $ paid by the health plan in 2010 (medical and Rx)"]
["RX_PMPM_2010","accounting","Cost / total $ paid by the health plan on prescrptions per month in 2010"]
["RX_PMPM_2011","accounting","Cost / total $ paid by the health plan on prescriptions per month in 2011"]
["TOTAL_PAID_2011","accounting","Total $ paid by the health plan in 2011 (medical and Rx)"]
["TOTAL_PMPM_2010","accounting","Total Cost / total $ paid by the health plan for medical AND Rx per month in 2010"]
["TOTAL_PMPM_2011","accounting","Total Cost / total $ paid by the health plan for medical AND Rx per month in 2011"]
["TOTAL_PMPM_PCT_2010","number (0 decimals)","Percentile of PMPM in 2010 relative to population (e.g., 10% means 10% of members had a lower PMPM than this member in 2010) "]
["TOTAL_PMPM_PCT_2011","number (0 decimals)","Percentile of PMPM in 2011 relative to population (e.g., 10% means 10% of members had a lower PMPM than this member in 2011) "]
["TOTAL_BH_2010","accounting","Total behavioral health costs in 2010 -- these are carved out and provided by Community Care Behavioral Health (CCHB) -- not included in costs shown in the model"]
["TOTAL_BH_2011","accounting","Total behavioral health costs in 2011 -- these are carved out and provided by Community Care Behavioral Health (CCHB) -- not included in costs shown in the model"]
["MEM_MOS_2010","number (0 decimals)","Number of months in 2010 that this person was a member"]
["MEM_MOS_2011","number (0 decimals)","Number of months in 2011 that this person was a member"]
["Fields with a \"CC\" pre-fix (rows 153 - 189) indicate chronic conditions that have been attributed to the member.  1 indicates \"yes - the member has been diagnosed with the chronic condition\".  0 indicates \"no, the member has not been diagnosed with the chronic condition\"."]
["CC_ASTHMA","number (0 decimals)","Flag for asthma"]
["CC_COPD","number (0 decimals)","Flag for COPD"]
["CC_CHF","number (0 decimals)","Flag for chronic heart failure"]
["CC_CAD","number (0 decimals)","Flag for coronary artery disease"]
["CC_DM","number (0 decimals)","Flag for diabetes"]
["CC_MORBID_OBESITY","number (0 decimals)","Flag for morbid obesity"]
["CC_HYPERLIPIDEMIA","number (0 decimals)","Flag for hyperlipidemia"]
["CC_HYPERTENSION","number (0 decimals)","Flag for hypertension"]
["CC_RHEUMA_ARTHRITIS","number (0 decimals)","Flag for rheumatoid arthritis"]
["CC_OSTEOARTHRITIS","number (0 decimals)","Flag for osteoarthritis"]
["CC_LUPUS_CONN_TISSUE_DISORDERS","number (0 decimals)","Flag for lupus"]
["CC_ATRIAL_FIBRILLATION","number (0 decimals)","Flag for atrial fibrillation"]
["CC_CENTRAL_NERV_SYS_DISEASE","number (0 decimals)","Flag for CNS disease"]
["CC_CEREBRAL_PALSY","number (0 decimals)","Flag for cerbral palsy"]
["CC_CEREBRO_VASCULAR_DISEASE","number (0 decimals)","Flag for cerebro vascular disease"]
["CC_CHRONIC_HEPATITIS","number (0 decimals)","Flag for chronic hepatitis"]
["CC_COAGULATION_DEFECTS","number (0 decimals)","Flag for coagulation defects"]
["CC_CYSTIC_FIBROSIS","number (0 decimals)","Flag for cystic fibrosis"]
["CC_EPILEPSY","number (0 decimals)","Flag for epilepsy"]
["CC_ESRD","number (0 decimals)","Flag for ESRD"]
["CC_HEMATOLOGICAL_SICKLE_CELL","number (0 decimals)","Flag for hematological sickel cell anemia"]
["CC_HIV","number (0 decimals)","Flag for HIV"]
["CC_IMMUNE_DEFICIENCY","number (0 decimals)","Flag for immune deficiency"]
["CC_INFLAMMATORY_BOWEL_DISEASE","number (0 decimals)","Flag for inflammatory bowel disease"]
["CC_LIVER_DISEASE","number (0 decimals)","Flag fo liver disease"]
["CC_MIGRAINE","number (0 decimals)","Flag for migraines"]
["CC_MULTIPLE_SCLEROSIS","number (0 decimals)","Flag for multiple sclerosis"]
["CC_MUSCULAR_DYSTROPHY","number (0 decimals)","Flag for muscular dystrophy"]
["CC_MYASTHENIA_GRAVIS","number (0 decimals)","Flag for myasthenia gravis"]
["CC_NEOPLASM_MALIGNANT","number (0 decimals)","Flag for neoplasm malignant"]
["CC_OSTEOPOROSIS","number (0 decimals)","Flag for osteoporosis"]
["CC_PANCREATITIS_CHRONIC","number (0 decimals)","Flag for chronic pancreatitis"]
["CC_PARALYSIS","number (0 decimals)","Flag for paralysis"]
["CC_PARKINSONS_DISEASE","number (0 decimals)","Flag for Parkinsons disease"]
["CC_RENAL_DISEASE","number (0 decimals)","Flag for renal disease"]
["CC_TRANSPLANT","number (0 decimals)","Flag for transplant"]
["CC_SPINA_BIFIDA_SCI","number (0 decimals)","Flag for spina bifida"]
["SPEC_ANESTHESIOLOGY","accounting","Total $ paid by the health plan related to specialist visits for anesthesiology"]
["SPEC_ORTHO_SURG","accounting","Total $ paid by the health plan related to specialist visits for orthopedic surgery"]
["SPEC_OBGYN","accounting","Total $ paid by the health plan related to specialist visits for obstetrics/gynecology"]
["SPEC_OTOLARYNGOLOGY","accounting","Total $ paid by the health plan related to specialist visits for otolaryngology"]
["SPEC_ENDOCRINOLOGY","accounting","Total $ paid by the health plan related to specialist visits for endocrinology"]
["SPEC_GASTROENTEROLOGY","accounting","Total $ paid by the health plan related to specialist visits for gastroenterology"]
["SPEC_CARDIOLOGY","accounting","Total $ paid by the health plan related to specialist visits for cardiology"]
["SPEC_NEUROLOGY","accounting","Total $ paid by the health plan related to specialist visits for neurology"]
["SPEC_NEURO_SURG","accounting","Total $ paid by the health plan related to specialist visits for neurological surgery"]
["SPEC_ORAL_MAXILLO_SURG","accounting","Total $ paid by the health plan related to specialist visits for oral maxillo surgery"]
["SPEC_HEMO_ONCOLOGY","accounting","Total $ paid by the health plan related to specialist visits for hematology/oncology"]
["SPEC_OPHTHALMOLOGY","accounting","Total $ paid by the health plan related to specialist visits for ophthalmology"]
["SPEC_ALLERGY_IMMUNE","accounting","Total $ paid by the health plan related to specialist visits for immune allergy"]
["SPEC_SURGERY","accounting","Total $ paid by the health plan related to specialist visits for surgery"]
["SPEC_PULMONOLOGY","accounting","Total $ paid by the health plan related to specialist visits for pulmonology"]
["SPEC_DERMATOLOGY","accounting","Total $ paid by the health plan related to specialist visits for dermatology"]
["SPEC_UROLOGY","accounting","Total $ paid by the health plan related to specialist visits for urology"]
["SPEC_PLASTIC_SURG","accounting","Total $ paid by the health plan related to specialist visits for plastic surgery"]
["SPEC_NEPHROLOGY","accounting","Total $ paid by the health plan related to specialist visits for nephrology"]
["SPEC_ALL_OTHERS","accounting","Total $ paid by the health plan related to visits with all other specialties"]
["CC_SPEND_ASTHMA","accounting","Asthma  - total $ paid by the health plan"]
["CC_SPEND_COPD","accounting","COPD  - total $ paid by the health plan"]
["CC_SPEND_CHF","accounting","Chronic Heart Failure  - total $ paid by the health plan"]
["CC_SPEND_CAD","accounting","Coronary Artery Disease  - total $ paid by the health plan"]
["CC_SPEND_DM","accounting","Diabetes  - total $ paid by the health plan"]
["CC_SPEND_MORBID_OBESITY","accounting","Morbid Obesity  - total $ paid by the health plan"]
["CC_SPEND_HYPERLIPIDEMIA","accounting","Hyperlipidemia  - total $ paid by the health plan"]
["CC_SPEND_HYPERTENSION","accounting","Hypertension  - total $ paid by the health plan"]
["CC_SPEND_RHEUMA_ART","accounting","Rheumatoid Arthritis  - total $ paid by the health plan"]
["CC_SPEND_OSTEO","accounting","Osteoarthritis  - total $ paid by the health plan"]
["CC_SPEND_LUPUS","accounting","Lupus  - total $ paid by the health plan"]
["CC_SPEND_AFIB","accounting","Atrial Fibrillation  - total $ paid by the health plan"]
["CC_SPEND_CENT_NERV","accounting","CNS Disease  - total $ paid by the health plan"]
["CC_SPEND_CERE_PALSY","accounting","Cerbral Palsy  - total $ paid by the health plan"]
["CC_SPEND_CERE_VASC_DIS","accounting","Cerebrovascular Disease  - total $ paid by the health plan"]
["CC_SPEND_CHR_HEPATITIS","accounting","Chronic Hepatitis  - total $ paid by the health plan"]
["CC_SPEND_COAG","accounting","Coagulation Defects  - total $ paid by the health plan"]
["CC_SPEND_CYSTIC_FIBR","accounting","Cystic Fibrosis  - total $ paid by the health plan"]
["CC_SPEND_EPILEPSY","accounting","Epilepsy  - total $ paid by the health plan"]
["CC_SPEND_ESRD","accounting","Esrd  - total $ paid by the health plan"]
["CC_SPEND_HEMA_SICKLE_CELL","accounting","Hematological Sickel Cell Anemia  - total $ paid by the health plan"]
["CC_SPEND_HIV","accounting","HIV  - total $ paid by the health plan"]
["CC_SPEND_IMMUNE_DEF","accounting","Immune Deficiency  - total $ paid by the health plan"]
["CC_SPEND_IBD","accounting","Inflammatory Bowel Disease  - total $ paid by the health plan"]
["CC_SPEND_LIVER_DISEASE","accounting","Liver Disease  - total $ paid by the health plan"]
["CC_SPEND_MIGRAINE","accounting","Migraines  - total $ paid by the health plan"]
["CC_SPEND_MS","accounting","Multiplesclerosis  - total $ paid by the health plan"]
["CC_SPEND_MUSCULAR_DYST","accounting","Muscular Dystrophy  - total $ paid by the health plan"]
["CC_SPEND_MYASTHENIA_GRAVIS","accounting","Myasthenia Gravis  - total $ paid by the health plan"]
["CC_SPEND_NEOPLASM","accounting","Neoplasm Malignant  - total $ paid by the health plan"]
["CC_SPEND_OSTEOPOROSIS","accounting","Osteoporosis  - total $ paid by the health plan"]
["CC_SPEND_PANCREATITIS","accounting","Chronic Pancreatitis  - total $ paid by the health plan"]
["CC_SPEND_PARALYSIS","accounting","Paralysis  - total $ paid by the health plan"]
["CC_SPEND_PARKINSONS","accounting","Parkinsons Disease  - total $ paid by the health plan"]
["CC_SPEND_RENAL_DISEASE","accounting","Renal Disease  - total $ paid by the health plan"]
["CC_SPEND_TRANSPLANT","accounting","Transplant  - total $ paid by the health plan"]
["CC_SPEND_SB_SCI","accounting","Spina Bifida  - total $ paid by the health plan"]
["CC_TOTAL","formula","Number of chronic conditions"]
["CC_TOTAL_IND_0","formula","Flag if member has zero chronic conditions (1 = yes, 0 = no)"]
["CC_TOTAL_IND_1","formula","Flag if member has one chronic condition (1 = yes, 0 = no)"]
["CC_TOTAL_IND_2","formula","Flag if member has two chronic conditions  (1 = yes, 0 = no)"]
["CC_TOTAL_IND_3","formula","Flag if member has three chronic conditions  (1 = yes, 0 = no)"]
["CC_TOTAL_IND_4","formula","Flag if member has four chronic conditions (1 = yes, 0 = no)"]
["CC_TOTAL_IND_Over 5","formula","Flag if member has five or more chronic conditions (1 = yes, 0 = no)"]
["COUNT_FLAG","formula","Flag for determining which members to include/exclude from output based on user inputs"]
["COUNT_FLAG","formula","Flag for determining which members to include/exclude from output based on user inputs"]
["GENDER_CODE_IND","formula","Flag for female gender (1 = female, 0 = male)"]
["Group_TEXT_IND","formula","Flag to identify Group A vs Group B members"]
["TOTAL_DME_MED_SUPPLY_PGA_2010","formula","Total $ paid by the health plan for durable medical equipment &  medical supplies in 2010"]
["TOTAL_DME_MED_SUPPLY_PGA_2011","formula","Total $ paid by the health plan for durable medical equipment &  medical supplies in 2011"]
["BH_TOTAL_PGA_2010","formula","Total $ paid by the health plan on inpatient and outpatient behavioral health services in 2010"]
["BH_TOTAL_PGA_2011","formula","Total $ paid by the health plan on inpatient and outpatient behavioral health services in 2011"]
["DME_MED_SUPPLY_CLAIMS_TOTAL_2010","formula","Total durable medical equipment & medical supply claims in 2010"]
["DME_MED_SUPPLY_CLAIMS_TOTAL_2011","formula","Total durable medical equipment & medical supply claims in 2011"]
["BH_TOTAL_CLAIMS_2010","formula","Total inpatient and outpatient behavioral health claims in 2010"]
["BH_TOTAL_CLAIMS_2011","formula","Total inpatient and outpatient behavioral health claims in 2011"]
["TOTAL_MED","formula","Total $ paid by the health plan on medical (non-Rx) services across 2010 and 2011"]
["TOTAL_RX","formula","Total $ paid by the health plan on prescription drugs in 2010 and 2011"]
["TOTAL_PAID","formula","Total $ paid by the health plan in 2010 and 2011 (medical and Rx)"]
["TOTAL_PMPM","formula","Total Cost / total $ paid by the health plan for medical AND Rx per month in 2010 and 2011"]
["MEM_MOS_TOTAL","formula","Number of months across 2010 and 2011 that this person was a member"]
["SIGNIFICANT_%","formula","Calculation associated with the year 2 PMPM % mark-up threshold that users enter (to define episodic spending)"]
["SIGNIFICANT THRESHOLD","formula","Calculation that determines episodic threshold in dollars (based on the % users enter)"]
["#_ABOVE_THRESHOLD","formula","Calculation that determines total member months above the episodic spending threshold"]
["PAID_201001_IND","formula","Flag for being above episodic spending threshold in month listed in variable's name (1 = above the threshold)"]
["PAID_201002_IND","formula","Flag for being above episodic spending threshold in month listed in variable's name (1 = above the threshold)"]
["PAID_201003_IND","formula","Flag for being above episodic spending threshold in month listed in variable's name (1 = above the threshold)"]
["PAID_201004_IND","formula","Flag for being above episodic spending threshold in month listed in variable's name (1 = above the threshold)"]
["PAID_201005_IND","formula","Flag for being above episodic spending threshold in month listed in variable's name (1 = above the threshold)"]
["PAID_201006_IND","formula","Flag for being above episodic spending threshold in month listed in variable's name (1 = above the threshold)"]
["PAID_201007_IND","formula","Flag for being above episodic spending threshold in month listed in variable's name (1 = above the threshold)"]
["PAID_201008_IND","formula","Flag for being above episodic spending threshold in month listed in variable's name (1 = above the threshold)"]
["PAID_201009_IND","formula","Flag for being above episodic spending threshold in month listed in variable's name (1 = above the threshold)"]
["PAID_201010_IND","formula","Flag for being above episodic spending threshold in month listed in variable's name (1 = above the threshold)"]
["PAID_201011_IND","formula","Flag for being above episodic spending threshold in month listed in variable's name (1 = above the threshold)"]
["PAID_201012_IND","formula","Flag for being above episodic spending threshold in month listed in variable's name (1 = above the threshold)"]
["PAID_201101_IND","formula","Flag for being above episodic spending threshold in month listed in variable's name (1 = above the threshold)"]
["PAID_201102_IND","formula","Flag for being above episodic spending threshold in month listed in variable's name (1 = above the threshold)"]
["PAID_201103_IND","formula","Flag for being above episodic spending threshold in month listed in variable's name (1 = above the threshold)"]
["PAID_201104_IND","formula","Flag for being above episodic spending threshold in month listed in variable's name (1 = above the threshold)"]
["PAID_201105_IND","formula","Flag for being above episodic spending threshold in month listed in variable's name (1 = above the threshold)"]
["PAID_201106_IND","formula","Flag for being above episodic spending threshold in month listed in variable's name (1 = above the threshold)"]
["PAID_201107_IND","formula","Flag for being above episodic spending threshold in month listed in variable's name (1 = above the threshold)"]
["PAID_201108_IND","formula","Flag for being above episodic spending threshold in month listed in variable's name (1 = above the threshold)"]
["PAID_201109_IND","formula","Flag for being above episodic spending threshold in month listed in variable's name (1 = above the threshold)"]
["PAID_201110_IND","formula","Flag for being above episodic spending threshold in month listed in variable's name (1 = above the threshold)"]
["PAID_201111_IND","formula","Flag for being above episodic spending threshold in month listed in variable's name (1 = above the threshold)"]
["PAID_201112_IND","formula","Flag for being above episodic spending threshold in month listed in variable's name (1 = above the threshold)"]
["SPEC_ANESTHESIOLOGY_IND","formula","Flag for spending associated with anesthesiology specialist visits (1 = spending, 0 = no spending)"]
["SPEC_ORTHO_SURG_IND","formula","Flag for spending associated with orthopedic surgery specialist visits (1 = spending, 0 = no spending)"]
["SPEC_OBGYN_IND","formula","Flag for spending associated with OBGYN visits (1 = spending, 0 = no spending)"]
["SPEC_OTOLARYNGOLOGY_IND","formula","Flag for spending associated with otolaryngology specialist visits (1 = spending, 0 = no spending)"]
["SPEC_ENDOCRINOLOGY_IND","formula","Flag for spending associated with endocrinology specialist visits (1 = spending, 0 = no spending)"]
["SPEC_GASTROENTEROLOGY_IND","formula","Flag for spending associated with gastroenterology specialist visits (1 = spending, 0 = no spending)"]
["SPEC_CARDIOLOGY_IND","formula","Flag for spending associated with cardiology specialist visits (1 = spending, 0 = no spending)"]
["SPEC_NEUROLOGY_IND","formula","Flag for spending associated with neurology specialist visits (1 = spending, 0 = no spending)"]
["SPEC_NEURO_SURG_IND","formula","Flag for spending associated with neurological surgery specialist visits (1 = spending, 0 = no spending)"]
["SPEC_ORAL_MAXILLO_SURG_IND","formula","Flag for spending associated with oral maxillo surgery specialist visits (1 = spending, 0 = no spending)"]
["SPEC_HEMO_ONCOLOGY_IND","formula","Flag for spending associated with hematology/oncology specialist visits (1 = spending, 0 = no spending)"]
["SPEC_OPHTHALMOLOGY_IND","formula","Flag for spending associated with ophthalmology specialist visits (1 = spending, 0 = no spending)"]
["SPEC_ALLERGY_IMMUNE_IND","formula","Flag for spending associated with immune allergy specialist visits (1 = spending, 0 = no spending)"]
["SPEC_SURGERY_IND","formula","Flag for spending associated with surgery specialist visits (1 = spending, 0 = no spending)"]
["SPEC_PULMONOLOGY_IND","formula","Flag for spending associated with pulmonology specialist visits (1 = spending, 0 = no spending)"]
["SPEC_DERMATOLOGY_IND","formula","Flag for spending associated with dermatology specialist visits (1 = spending, 0 = no spending)"]
["SPEC_UROLOGY_IND","formula","Flag for spending associated with urology specialist visits (1 = spending, 0 = no spending)"]
["SPEC_PLASTIC_SURG_IND","formula","Flag for spending associated with plastic surgery specialist visits (1 = spending, 0 = no spending)"]
["SPEC_NEPHROLOGY_IND","formula","Flag for spending associated with nephrology specialist visits (1 = spending, 0 = no spending)"]
["SPEC_ALL_OTHERS_IND","formula","Flag for spending associated with all other specialist visits (1 = spending, 0 = no spending)"]
["SPEC_ANY_IND","formula","Flag for spending associated with any type of specialist visits (1 = spending, 0 = no spending)"]
["THRESH_0","formula","Flag (1 if true) for zero member months above the user-determined spending threshold"]
["THRESH_1","formula","Flag (1 if true) for 1 member month above the user-determined spending threshold"]
["THRESH_2","formula","Flag (1 if true) for 2 member months above the user-determined spending threshold"]
["THRESH_3","formula","Flag (1 if true) for 3 member months above the user-determined spending threshold"]
["THRESH_4","formula","Flag (1 if true) for 4 member months above the user-determined spending threshold"]
["THRESH_5","formula","Flag (1 if true) for 5 member months above the user-determined spending threshold"]
["THRESH_6","formula","Flag (1 if true) for 6 member months above the user-determined spending threshold"]
["THRESH_7","formula","Flag (1 if true) for 7 member months above the user-determined spending threshold"]
["THRESH_8","formula","Flag (1 if true) for 8 member months above the user-determined spending threshold"]
["THRESH_9","formula","Flag (1 if true) for 9 member months above the user-determined spending threshold"]
["THRESH_10","formula","Flag (1 if true) for 10 member months above the user-determined spending threshold"]
["THRESH_11","formula","Flag (1 if true) for 11 member months above the user-determined spending threshold"]
["THRESH_12","formula","Flag (1 if true) for 12 member months above the user-determined spending threshold"]
["THRESH_13","formula","Flag (1 if true) for 13 member months above the user-determined spending threshold"]
["THRESH_14","formula","Flag (1 if true) for 14 member months above the user-determined spending threshold"]
["THRESH_15","formula","Flag (1 if true) for 15 member months above the user-determined spending threshold"]
["THRESH_16","formula","Flag (1 if true) for 16 member months above the user-determined spending threshold"]
["THRESH_17","formula","Flag (1 if true) for 17 member months above the user-determined spending threshold"]
["THRESH_18","formula","Flag (1 if true) for 18 member months above the user-determined spending threshold"]
["THRESH_19","formula","Flag (1 if true) for 19 member months above the user-determined spending threshold"]
["THRESH_20","formula","Flag (1 if true) for 20 member months above the user-determined spending threshold"]
["THRESH_21","formula","Flag (1 if true) for 21 member months above the user-determined spending threshold"]
["THRESH_22","formula","Flag (1 if true) for 22 member months above the user-determined spending threshold"]
["THRESH_23","formula","Flag (1 if true) for 23 member months above the user-determined spending threshold"]
["THRESH_24","formula","Flag (1 if true) for 24 member months above the user-determined spending threshold"]
["TOTAL_BH","formula","Total behavioral health costs paid by Community Care Behavioral Health (CCBH) in 2010 and 2011 -- these costs are carved out and not reflected in the model"]
["TOTAL_MED_RX_BH_2010","formula","Total $ paid by the health plan for medical, prescription and behavioral health services in 2010"]
["TOTAL_MED_RX_BH_2011","formula","Total $ paid by the health plan for medical, prescription and behavioral health services in 2011"]
["MED_RX_BH_TOTAL","formula","Total $ paid by the health plan for medical, prescription and behavioral health services in 2010 and 2011"]

{"sheet":"Input","index":3,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[],"read":"part_too_large"}

{"sheet":"Drop Down Lists","index":4,"n_rows":29,"n_cols":15,"rows_kept":29,"cut":false,"hidden":false,"merged":[]}
["Drop Down Lists"]
[]
["Group",null,"PMPM Percentile 2010",null,"PMPM Percentile 2011",null,"Range",null,"% Over Threshold",null,"# of Times Above Threshold",null,"Year",null,"Flags"]
[]
[]
["All",null,0,null,0,null,"Lower Range",null,0,null,1,null,"Total",null,0]
["Group A",null,10,null,10,null,"Upper Range",null,0.1,null,2,null,2010,null,1]
["Group B",null,20,null,20,null,"Exact",null,0.15,null,3,null,2011,null,2]
[null,null,30,null,30,null,null,null,0.2,null,4,null,null,null,3]
[null,null,40,null,40,null,null,null,0.25,null,5,null,null,null,4]
[null,null,50,null,50,null,null,null,0.3,null,6,null,null,null,5]
[null,null,60,null,60,null,null,null,0.35,null,7]
[null,null,70,null,70,null,null,null,0.4,null,8]
[null,null,80,null,80,null,null,null,0.45,null,9]
[null,null,90,null,90,null,null,null,0.5,null,10]
[null,null,100,null,100,null,null,null,0.55000000000000004,null,11]
[null,null,null,null,null,null,null,null,0.6,null,12]
[null,null,null,null,null,null,null,null,0.7,null,13]
[null,null,null,null,null,null,null,null,0.8,null,14]
[null,null,null,null,null,null,null,null,0.9,null,15]
[null,null,null,null,null,null,null,null,1,null,16]
[null,null,null,null,null,null,null,null,null,null,17]
[null,null,null,null,null,null,null,null,null,null,18]
[null,null,null,null,null,null,null,null,null,null,19]
[null,null,null,null,null,null,null,null,null,null,20]
[null,null,null,null,null,null,null,null,null,null,21]
[null,null,null,null,null,null,null,null,null,null,22]
[null,null,null,null,null,null,null,null,null,null,23]
[null,null,null,null,null,null,null,null,null,null,24]

{"sheet":"Macro_Data","index":5,"n_rows":143,"n_cols":56,"rows_kept":143,"cut":false,"hidden":false,"merged":[]}
["DO NOT DELETE…",null,null,null,"Charts"]
[]
[]
[null,null,null,null,null,"% of Selected Population by Number of Chronic Conditions",null,null,null,"N","Labels",null,null,"Basis Population PMPM",null,null,null,null,null,"Number of Times Over Threshold",null,null,null,null,null,null,"Selection Illustration",null,null,null,null,null,null,null,null,"Refresh Pivot",null,null,null,null,null,null,null,"Top 10 for Bubble",null,null,null,null,null,null,"CC"]
[null,null,null,null,null,"Chronic Conditions","% of Selected Population",null,null,{"$f":"SUMIF(Input!$IJ$2:$IJ$25001,1)","v":9},0,null,null,null,null,null,null,null,null,"#","N","N2","N3","N4","Nlabels",null,null,null,null,null,null,null,null,null,null,"Row Labels","Total Spend","Occurences","Prevalence","Size","Sum of PMPM",null,null,null,"Total Spend","PMPM","Occurences","Prevalence","Size",null,null,null,"Occurences","PMPM","Total Spend","Prevalence"]
[null,null,null,null,null,0,{"$f":"SUMIF(Input!$IJ$2:$IJ$25001,1)/'RWJF Population Model'!$Z$47","v":0.5},null,null,{"$f":"SUMIF(Input!$IK$2:$IK$25001,1)","v":7},0,null,null,2010,2011,"D","Total",null,null,0,{"$f":"IF(AND('RWJF Population Model'!$AO$25<>\"\",'RWJF Population Model'!$AO$23<>\"\",'RWJF Population Model'!$AO$36=\"\",'RWJF Population Model'!$AO$40=\"\"),SUMIF(Input!$IQ$2:$IQ$25001,1,Input!$LC$2:$LC$25001),0)","v":0},{"$f":"IF(AND('RWJF Population Model'!$AO$25<>\"\",'RWJF Population Model'!$AO$23<>\"\",'RWJF Population Model'!$AO$36<>\"\",'RWJF Population Model'!$AO$40=\"\"),SUMIF(Input!$IQ$2:$IQ$25001,1,Input!$LC$2:$LC$25001),0)","v":2},{"$f":"IF(AND('RWJF Population Model'!$AO$25<>\"\",'RWJF Population Model'!$AO$23<>\"\",'RWJF Population Model'!$AO$36<>\"\",'RWJF Population Model'!$AO$40<>\"\"),SUMIF(Input!$IQ$2:$IQ$25001,1,Input!$LC$2:$LC$25001),0)","v":0},{"$f":"IF(T6>='RWJF Population Model'!$AO$40,W6,0)","v":0},{"$f":"IF(U6<>0,U6,IF(V6<>0,V6,IF(W6<>0,W6,\"\")))","v":2},null,20,40,40,null,null,null,null,null,null,"ASTHMA",3432.13,16,0.33333333333333331,149.22304347826088,6.0638339222614839,null,1,{"$f":"AJ6","v":"ASTHMA"},{"$f":"AK6","v":3432.13},{"$f":"AO6","v":6.0638339222614839},{"$f":"AL6","v":16},{"$f":"AM6","v":0.33333333333333331},{"$f":"AN6","v":149.22304347826088},null,1,{"$f":"AJ6","v":"ASTHMA"},{"$f":"AL6","v":16},{"$f":"AO6","v":6.0638339222614839},{"$f":"AK6","v":3432.13},{"$f":"AM6","v":0.33333333333333331}]
[null,null,null,null,null,1,{"$f":"SUMIF(Input!$IK$2:$IK$25001,1)/'RWJF Population Model'!$Z$47","v":0.3888888888888889},null,null,{"$f":"SUMIF(Input!$IL$2:$IL$25001,1)","v":1},0,null,null,null,null,null,null,null,null,1,{"$f":"IF(AND('RWJF Population Model'!$AO$25<>\"\",'RWJF Population Model'!$AO$23<>\"\",'RWJF Population Model'!$AO$36=\"\",'RWJF Population Model'!$AO$40=\"\"),SUMIF(Input!$IQ$2:$IQ$25001,1,Input!$LD$2:$LD$25001),0)","v":0},{"$f":"IF(AND('RWJF Population Model'!$AO$25<>\"\",'RWJF Population Model'!$AO$23<>\"\",'RWJF Population Model'!$AO$36<>\"\",'RWJF Population Model'!$AO$40=\"\"),SUMIF(Input!$IQ$2:$IQ$25001,1,Input!$LD$2:$LD$25001),0)","v":2},{"$f":"IF(AND('RWJF Population Model'!$AO$25<>\"\",'RWJF Population Model'!$AO$23<>\"\",'RWJF Population Model'!$AO$36<>\"\",'RWJF Population Model'!$AO$40<>\"\"),SUMIF(Input!$IQ$2:$IQ$25001,1,Input!$LD$2:$LD$25001),0)","v":0},{"$f":"IF(T7>='RWJF Population Model'!$AO$40,W7,0)","v":0},{"$f":"IF(U7<>0,U7,IF(V7<>0,V7,IF(W7<>0,W7,\"\")))","v":2},null,20,40,40,null,null,null,null,null,null,"DM",616.32000000000005,1,2.0833333333333332E-2,26.796521739130437,1.088904593639576,null,2,{"$f":"AJ7","v":"DM"},{"$f":"AK7","v":616.32000000000005},{"$f":"AO7","v":1.088904593639576},{"$f":"AL7","v":1},{"$f":"AM7","v":2.0833333333333332E-2},{"$f":"AN7","v":26.796521739130437},null,2,{"$f":"AJ7","v":"DM"},{"$f":"AL7","v":1},{"$f":"AO7","v":1.088904593639576},{"$f":"AK7","v":616.32000000000005},{"$f":"AM7","v":2.0833333333333332E-2}]
[null,null,null,null,null,2,{"$f":"SUMIF(Input!$IL$2:$IL$25001,1)/'RWJF Population Model'!$Z$47","v":5.5555555555555552E-2},null,null,{"$f":"SUMIF(Input!$IM$2:$IM$25001,1)","v":0},0,null,null,{"$f":"SUMIF(Input!$IQ$2:$IQ$25001,1,Input!$EG$2:$EG$25001)/SUMIF(Input!$IQ$2:$IQ$25001,1,Input!$EQ$2:$EQ$25001)","v":204.79124999999999},{"$f":"SUMIF(Input!$IQ$2:$IQ$25001,1,Input!$EJ$2:$EJ$25001)/SUMIF(Input!$IQ$2:$IQ$25001,1,Input!$ER$2:$ER$25001)","v":381.77538461538472},{"$f":"O8-N8","v":176.98413461538473},{"$f":"SUMIF(Input!$IQ$2:$IQ$25001,1,Input!$JD$2:$JD$25001)/SUMIF(Input!$IQ$2:$IQ$25001,1,Input!$JF$2:$JF$25001)","v":291.61365566037739},null,null,2,{"$f":"IF(AND('RWJF Population Model'!$AO$25<>\"\",'RWJF Population Model'!$AO$23<>\"\",'RWJF Population Model'!$AO$36=\"\",'RWJF Population Model'!$AO$40=\"\"),SUMIF(Input!$IQ$2:$IQ$25001,1,Input!$LE$2:$LE$25001),0)","v":0},{"$f":"IF(AND('RWJF Population Model'!$AO$25<>\"\",'RWJF Population Model'!$AO$23<>\"\",'RWJF Population Model'!$AO$36<>\"\",'RWJF Population Model'!$AO$40=\"\"),SUMIF(Input!$IQ$2:$IQ$25001,1,Input!$LE$2:$LE$25001),0)","v":1},{"$f":"IF(AND('RWJF Population Model'!$AO$25<>\"\",'RWJF Population Model'!$AO$23<>\"\",'RWJF Population Model'!$AO$36<>\"\",'RWJF Population Model'!$AO$40<>\"\"),SUMIF(Input!$IQ$2:$IQ$25001,1,Input!$LE$2:$LE$25001),0)","v":0},{"$f":"IF(T8>='RWJF Population Model'!$AO$40,W8,0)","v":0},1,null,null,null,null,null,null,null,null,null,null,"SPINA BIFIDA SCI",0,0,0,0,0,null,3,"SPINA BIFIDA SCI",0,0,0,0,0,null,3,"SPINA BIFIDA SCI",0,0,0,0]
[null,null,null,null,null,3,{"$f":"SUMIF(Input!$IM$2:$IM$25001,1)/'RWJF Population Model'!$Z$47","v":0},null,null,{"$f":"SUMIF(Input!$IN$2:$IN$25001,1)","v":1},0,null,null,null,null,null,null,null,null,3,{"$f":"IF(AND('RWJF Population Model'!$AO$25<>\"\",'RWJF Population Model'!$AO$23<>\"\",'RWJF Population Model'!$AO$36=\"\",'RWJF Population Model'!$AO$40=\"\"),SUMIF(Input!$IQ$2:$IQ$25001,1,Input!$LF$2:$LF$25001),0)","v":0},{"$f":"IF(AND('RWJF Population Model'!$AO$25<>\"\",'RWJF Population Model'!$AO$23<>\"\",'RWJF Population Model'!$AO$36<>\"\",'RWJF Population Model'!$AO$40=\"\"),SUMIF(Input!$IQ$2:$IQ$25001,1,Input!$LF$2:$LF$25001),0)","v":2},{"$f":"IF(AND('RWJF Population Model'!$AO$25<>\"\",'RWJF Population Model'!$AO$23<>\"\",'RWJF Population Model'!$AO$36<>\"\",'RWJF Population Model'!$AO$40<>\"\"),SUMIF(Input!$IQ$2:$IQ$25001,1,Input!$LF$2:$LF$25001),0)","v":0},{"$f":"IF(T9>='RWJF Population Model'!$AO$40,W9,0)","v":0},2,null,{"$f":"IF('RWJF Population Model'!$AO$40=\"\",\"\",\"Selected Population:\")","v":""},null,null,null,null,null,null,null,null,"NEOPLASM MALIGNANT",0,0,0,0,0,null,4,"NEOPLASM MALIGNANT",0,0,0,0,0,null,4,"NEOPLASM MALIGNANT",0,0,0,0]
[null,null,null,null,null,4,{"$f":"SUMIF(Input!$IN$2:$IN$25001,1)/'RWJF Population Model'!$Z$47","v":5.5555555555555552E-2},null,null,{"$f":"SUMIF(Input!$IO$2:$IO$25001,1)","v":0},0,null,null,null,null,null,null,null,null,4,{"$f":"IF(AND('RWJF Population Model'!$AO$25<>\"\",'RWJF Population Model'!$AO$23<>\"\",'RWJF Population Model'!$AO$36=\"\",'RWJF Population Model'!$AO$40=\"\"),SUMIF(Input!$IQ$2:$IQ$25001,1,Input!$LG$2:$LG$25001),0)","v":0},{"$f":"IF(AND('RWJF Population Model'!$AO$25<>\"\",'RWJF Population Model'!$AO$23<>\"\",'RWJF Population Model'!$AO$36<>\"\",'RWJF Population Model'!$AO$40=\"\"),SUMIF(Input!$IQ$2:$IQ$25001,1,Input!$LG$2:$LG$25001),0)","v":1},{"$f":"IF(AND('RWJF Population Model'!$AO$25<>\"\",'RWJF Population Model'!$AO$23<>\"\",'RWJF Population Model'!$AO$36<>\"\",'RWJF Population Model'!$AO$40<>\"\"),SUMIF(Input!$IQ$2:$IQ$25001,1,Input!$LG$2:$LG$25001),0)","v":0},{"$f":"IF(T10>='RWJF Population Model'!$AO$40,W10,0)","v":0},1,null,{"$f":"CONCATENATE(\"Medical and Rx PMPM of Initial Crossection\",\" - \",AH10)","v":"Medical and Rx PMPM of Initial Crossection - $292"},null,null,null,null,{"$f":"ROUND('RWJF Population Model'!$AO$27,0)","v":292},null,{"$f":"IF(AND(AF10>=1000,AF10<10000),CONCATENATE(\"$\",LEFT(AF10,1),\",\",MID(AF10,2,3)),IF(AF10>=10000,CONCATENATE(\"$\",LEFT(AF10,2),\",\",MID(AF10,3,3)),CONCATENATE(\"$\",LEFT(AF10,3))))","v":"$292"},null,"LUPUS CONN TISSUE DISORDERS",0,0,0,0,0,null,5,"LUPUS CONN TISSUE DISORDERS",0,0,0,0,0,null,5,"LUPUS CONN TISSUE DISORDERS",0,0,0,0]
[null,null,null,null,null,"5 or More",{"$f":"SUMIF(Input!$IO$2:$IO$25001,1)/'RWJF Population Model'!$Z$47","v":0},null,null,null,null,null,null,null,null,null,null,null,null,5,{"$f":"IF(AND('RWJF Population Model'!$AO$25<>\"\",'RWJF Population Model'!$AO$23<>\"\",'RWJF Population Model'!$AO$36=\"\",'RWJF Population Model'!$AO$40=\"\"),SUMIF(Input!$IQ$2:$IQ$25001,1,Input!$LH$2:$LH$25001),0)","v":0},{"$f":"IF(AND('RWJF Population Model'!$AO$25<>\"\",'RWJF Population Model'!$AO$23<>\"\",'RWJF Population Model'!$AO$36<>\"\",'RWJF Population Model'!$AO$40=\"\"),SUMIF(Input!$IQ$2:$IQ$25001,1,Input!$LH$2:$LH$25001),0)","v":1},{"$f":"IF(AND('RWJF Population Model'!$AO$25<>\"\",'RWJF Population Model'!$AO$23<>\"\",'RWJF Population Model'!$AO$36<>\"\",'RWJF Population Model'!$AO$40<>\"\"),SUMIF(Input!$IQ$2:$IQ$25001,1,Input!$LH$2:$LH$25001),0)","v":0},{"$f":"IF(T11>='RWJF Population Model'!$AO$40,W11,0)","v":0},1,null,{"$f":"IF('RWJF Population Model'!$AO$36=\"\",\"\",CONCATENATE(\"Monthly Episodic Spend Threshold\",\" - \",AH11))","v":"Monthly Episodic Spend Threshold - $292"},null,null,null,null,{"$f":"ROUND('RWJF Population Model'!$AO$38,0)","v":292},null,{"$f":"IF(AND(AF11>=1000,AF11<10000),CONCATENATE(\"$\",LEFT(AF11,1),\",\",MID(AF11,2,3)),IF(AF11>=10000,CONCATENATE(\"$\",LEFT(AF11,2),\",\",MID(AF11,3,3)),CONCATENATE(\"$\",LEFT(AF11,3))))","v":"$292"},null,"CENTRAL NERV SYS DISEASE",0,1,2.0833333333333332E-2,0,0,null,6,"CENTRAL NERV SYS DISEASE",0,0,1,2.0833333333333332E-2,0,null,6,"CENTRAL NERV SYS DISEASE",1,0,0,2.0833333333333332E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,{"$f":"IF(AND('RWJF Population Model'!$AO$25<>\"\",'RWJF Population Model'!$AO$23<>\"\",'RWJF Population Model'!$AO$36=\"\",'RWJF Population Model'!$AO$40=\"\"),SUMIF(Input!$IQ$2:$IQ$25001,1,Input!$LI$2:$LI$25001),0)","v":0},{"$f":"IF(AND('RWJF Population Model'!$AO$25<>\"\",'RWJF Population Model'!$AO$23<>\"\",'RWJF Population Model'!$AO$36<>\"\",'RWJF Population Model'!$AO$40=\"\"),SUMIF(Input!$IQ$2:$IQ$25001,1,Input!$LI$2:$LI$25001),0)","v":0},{"$f":"IF(AND('RWJF Population Model'!$AO$25<>\"\",'RWJF Population Model'!$AO$23<>\"\",'RWJF Population Model'!$AO$36<>\"\",'RWJF Population Model'!$AO$40<>\"\"),SUMIF(Input!$IQ$2:$IQ$25001,1,Input!$LI$2:$LI$25001),0)","v":0},{"$f":"IF(T12>='RWJF Population Model'!$AO$40,W12,0)","v":0},"",null,{"$f":"IF('RWJF Population Model'!$AO$40=\"\",\"\",CONCATENATE(AH12,\" Members with >/= \",AG12,\" Episodic Spend Months\"))","v":""},null,null,null,null,{"$f":"'RWJF Population Model'!$Z$47","v":18},{"$f":"'RWJF Population Model'!$AO$40","v":0},{"$f":"IF(AND(AF12>=1000,AF12<10000),CONCATENATE(LEFT(AF12,1),\",\",MID(AF12,2,3)),IF(AF12>=10000,CONCATENATE(LEFT(AF12,2),\",\",MID(AF12,3,3)),CONCATENATE(LEFT(AF12,3))))","v":"18"},null,"PARALYSIS",0,0,0,0,0,null,7,"PARALYSIS",0,0,0,0,0,null,7,"PARALYSIS",0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,{"$f":"IF(AND('RWJF Population Model'!$AO$25<>\"\",'RWJF Population Model'!$AO$23<>\"\",'RWJF Population Model'!$AO$36=\"\",'RWJF Population Model'!$AO$40=\"\"),SUMIF(Input!$IQ$2:$IQ$25001,1,Input!$LJ$2:$LJ$25001),0)","v":0},{"$f":"IF(AND('RWJF Population Model'!$AO$25<>\"\",'RWJF Population Model'!$AO$23<>\"\",'RWJF Population Model'!$AO$36<>\"\",'RWJF Population Model'!$AO$40=\"\"),SUMIF(Input!$IQ$2:$IQ$25001,1,Input!$LJ$2:$LJ$25001),0)","v":4},{"$f":"IF(AND('RWJF Population Model'!$AO$25<>\"\",'RWJF Population Model'!$AO$23<>\"\",'RWJF Population Model'!$AO$36<>\"\",'RWJF Population Model'!$AO$40<>\"\"),SUMIF(Input!$IQ$2:$IQ$25001,1,Input!$LJ$2:$LJ$25001),0)","v":0},{"$f":"IF(T13>='RWJF Population Model'!$AO$40,W13,0)","v":0},4,null,null,null,null,null,null,null,null,null,null,"CEREBRAL PALSY",0,1,2.0833333333333332E-2,0,0,null,8,"CEREBRAL PALSY",0,0,1,2.0833333333333332E-2,0,null,8,"CEREBRAL PALSY",1,0,0,2.0833333333333332E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,{"$f":"IF(AND('RWJF Population Model'!$AO$25<>\"\",'RWJF Population Model'!$AO$23<>\"\",'RWJF Population Model'!$AO$36=\"\",'RWJF Population Model'!$AO$40=\"\"),SUMIF(Input!$IQ$2:$IQ$25001,1,Input!$LK$2:$LK$25001),0)","v":0},{"$f":"IF(AND('RWJF Population Model'!$AO$25<>\"\",'RWJF Population Model'!$AO$23<>\"\",'RWJF Population Model'!$AO$36<>\"\",'RWJF Population Model'!$AO$40=\"\"),SUMIF(Input!$IQ$2:$IQ$25001,1,Input!$LK$2:$LK$25001),0)","v":1},{"$f":"IF(AND('RWJF Population Model'!$AO$25<>\"\",'RWJF Population Model'!$AO$23<>\"\",'RWJF Population Model'!$AO$36<>\"\",'RWJF Population Model'!$AO$40<>\"\"),SUMIF(Input!$IQ$2:$IQ$25001,1,Input!$LK$2:$LK$25001),0)","v":0},{"$f":"IF(T14>='RWJF Population Model'!$AO$40,W14,0)","v":0},1,null,null,null,null,null,null,null,null,null,null,"INFLAMMATORY BOWEL DISEASE",0,0,0,0,0,null,9,"INFLAMMATORY BOWEL DISEASE",0,0,0,0,0,null,9,"INFLAMMATORY BOWEL DISEASE",0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,{"$f":"IF(AND('RWJF Population Model'!$AO$25<>\"\",'RWJF Population Model'!$AO$23<>\"\",'RWJF Population Model'!$AO$36=\"\",'RWJF Population Model'!$AO$40=\"\"),SUMIF(Input!$IQ$2:$IQ$25001,1,Input!$LL$2:$LL$25001),0)","v":0},{"$f":"IF(AND('RWJF Population Model'!$AO$25<>\"\",'RWJF Population Model'!$AO$23<>\"\",'RWJF Population Model'!$AO$36<>\"\",'RWJF Population Model'!$AO$40=\"\"),SUMIF(Input!$IQ$2:$IQ$25001,1,Input!$LL$2:$LL$25001),0)","v":0},{"$f":"IF(AND('RWJF Population Model'!$AO$25<>\"\",'RWJF Population Model'!$AO$23<>\"\",'RWJF Population Model'!$AO$36<>\"\",'RWJF Population Model'!$AO$40<>\"\"),SUMIF(Input!$IQ$2:$IQ$25001,1,Input!$LL$2:$LL$25001),0)","v":0},{"$f":"IF(T15>='RWJF Population Model'!$AO$40,W15,0)","v":0},"",null,null,null,null,null,null,null,null,null,null,"CEREBRO VASCULAR DISEASE",0,0,0,0,0,null,10,"CEREBRO VASCULAR DISEASE",0,0,0,0,0,null,10,"CEREBRO VASCULAR DISEASE",0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,{"$f":"IF(AND('RWJF Population Model'!$AO$25<>\"\",'RWJF Population Model'!$AO$23<>\"\",'RWJF Population Model'!$AO$36=\"\",'RWJF Population Model'!$AO$40=\"\"),SUMIF(Input!$IQ$2:$IQ$25001,1,Input!$LM$2:$LM$25001),0)","v":0},{"$f":"IF(AND('RWJF Population Model'!$AO$25<>\"\",'RWJF Population Model'!$AO$23<>\"\",'RWJF Population Model'!$AO$36<>\"\",'RWJF Population Model'!$AO$40=\"\"),SUMIF(Input!$IQ$2:$IQ$25001,1,Input!$LM$2:$LM$25001),0)","v":1},{"$f":"IF(AND('RWJF Population Model'!$AO$25<>\"\",'RWJF Population Model'!$AO$23<>\"\",'RWJF Population Model'!$AO$36<>\"\",'RWJF Population Model'!$AO$40<>\"\"),SUMIF(Input!$IQ$2:$IQ$25001,1,Input!$LM$2:$LM$25001),0)","v":0},{"$f":"IF(T16>='RWJF Population Model'!$AO$40,W16,0)","v":0},1,null,null,null,null,null,null,null,null,null,null,"MORBID OBESITY",0,0,0,0,0,null,null,null,null,null,null,null,null,null,11,"MORBID OBESITY",0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,11,{"$f":"IF(AND('RWJF Population Model'!$AO$25<>\"\",'RWJF Population Model'!$AO$23<>\"\",'RWJF Population Model'!$AO$36=\"\",'RWJF Population Model'!$AO$40=\"\"),SUMIF(Input!$IQ$2:$IQ$25001,1,Input!$LN$2:$LN$25001),0)","v":0},{"$f":"IF(AND('RWJF Population Model'!$AO$25<>\"\",'RWJF Population Model'!$AO$23<>\"\",'RWJF Population Model'!$AO$36<>\"\",'RWJF Population Model'!$AO$40=\"\"),SUMIF(Input!$IQ$2:$IQ$25001,1,Input!$LN$2:$LN$25001),0)","v":0},{"$f":"IF(AND('RWJF Population Model'!$AO$25<>\"\",'RWJF Population Model'!$AO$23<>\"\",'RWJF Population Model'!$AO$36<>\"\",'RWJF Population Model'!$AO$40<>\"\"),SUMIF(Input!$IQ$2:$IQ$25001,1,Input!$LN$2:$LN$25001),0)","v":0},{"$f":"IF(T17>='RWJF Population Model'!$AO$40,W17,0)","v":0},"",null,null,null,null,null,null,null,null,null,null,"CHF",0,0,0,0,0,null,null,null,null,null,null,null,null,null,12,"CHF",0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,12,{"$f":"IF(AND('RWJF Population Model'!$AO$25<>\"\",'RWJF Population Model'!$AO$23<>\"\",'RWJF Population Model'!$AO$36=\"\",'RWJF Population Model'!$AO$40=\"\"),SUMIF(Input!$IQ$2:$IQ$25001,1,Input!$LO$2:$LO$25001),0)","v":0},{"$f":"IF(AND('RWJF Population Model'!$AO$25<>\"\",'RWJF Population Model'!$AO$23<>\"\",'RWJF Population Model'!$AO$36<>\"\",'RWJF Population Model'!$AO$40=\"\"),SUMIF(Input!$IQ$2:$IQ$25001,1,Input!$LO$2:$LO$25001),0)","v":0},{"$f":"IF(AND('RWJF Population Model'!$AO$25<>\"\",'RWJF Population Model'!$AO$23<>\"\",'RWJF Population Model'!$AO$36<>\"\",'RWJF Population Model'!$AO$40<>\"\"),SUMIF(Input!$IQ$2:$IQ$25001,1,Input!$LO$2:$LO$25001),0)","v":0},{"$f":"IF(T18>='RWJF Population Model'!$AO$40,W18,0)","v":0},"",null,null,null,null,null,null,null,null,null,null,"OSTEOPOROSIS",0,0,0,0,0,null,null,null,null,null,null,null,null,null,13,"OSTEOPOROSIS",0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,13,{"$f":"IF(AND('RWJF Population Model'!$AO$25<>\"\",'RWJF Population Model'!$AO$23<>\"\",'RWJF Population Model'!$AO$36=\"\",'RWJF Population Model'!$AO$40=\"\"),SUMIF(Input!$IQ$2:$IQ$25001,1,Input!$LP$2:$LP$25001),0)","v":0},{"$f":"IF(AND('RWJF Population Model'!$AO$25<>\"\",'RWJF Population Model'!$AO$23<>\"\",'RWJF Population Model'!$AO$36<>\"\",'RWJF Population Model'!$AO$40=\"\"),SUMIF(Input!$IQ$2:$IQ$25001,1,Input!$LP$2:$LP$25001),0)","v":0},{"$f":"IF(AND('RWJF Population Model'!$AO$25<>\"\",'RWJF Population Model'!$AO$23<>\"\",'RWJF Population Model'!$AO$36<>\"\",'RWJF Population Model'!$AO$40<>\"\"),SUMIF(Input!$IQ$2:$IQ$25001,1,Input!$LP$2:$LP$25001),0)","v":0},{"$f":"IF(T19>='RWJF Population Model'!$AO$40,W19,0)","v":0},"",null,null,null,null,null,null,null,null,null,null,"CHRONIC HEPATITIS",0,0,0,0,0,null,null,null,null,null,null,null,null,null,14,"CHRONIC HEPATITIS",0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,14,{"$f":"IF(AND('RWJF Population Model'!$AO$25<>\"\",'RWJF Population Model'!$AO$23<>\"\",'RWJF Population Model'!$AO$36=\"\",'RWJF Population Model'!$AO$40=\"\"),SUMIF(Input!$IQ$2:$IQ$25001,1,Input!$LQ$2:$LQ$25001),0)","v":0},{"$f":"IF(AND('RWJF Population Model'!$AO$25<>\"\",'RWJF Population Model'!$AO$23<>\"\",'RWJF Population Model'!$AO$36<>\"\",'RWJF Population Model'!$AO$40=\"\"),SUMIF(Input!$IQ$2:$IQ$25001,1,Input!$LQ$2:$LQ$25001),0)","v":1},{"$f":"IF(AND('RWJF Population Model'!$AO$25<>\"\",'RWJF Population Model'!$AO$23<>\"\",'RWJF Population Model'!$AO$36<>\"\",'RWJF Population Model'!$AO$40<>\"\"),SUMIF(Input!$IQ$2:$IQ$25001,1,Input!$LQ$2:$LQ$25001),0)","v":0},{"$f":"IF(T20>='RWJF Population Model'!$AO$40,W20,0)","v":0},1,null,null,null,null,null,null,null,null,null,null,"RENAL DISEASE",0,0,0,0,0,null,null,null,null,null,null,null,null,null,15,"RENAL DISEASE",0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15,{"$f":"IF(AND('RWJF Population Model'!$AO$25<>\"\",'RWJF Population Model'!$AO$23<>\"\",'RWJF Population Model'!$AO$36=\"\",'RWJF Population Model'!$AO$40=\"\"),SUMIF(Input!$IQ$2:$IQ$25001,1,Input!$LR$2:$LR$25001),0)","v":0},{"$f":"IF(AND('RWJF Population Model'!$AO$25<>\"\",'RWJF Population Model'!$AO$23<>\"\",'RWJF Population Model'!$AO$36<>\"\",'RWJF Population Model'!$AO$40=\"\"),SUMIF(Input!$IQ$2:$IQ$25001,1,Input!$LR$2:$LR$25001),0)","v":0},{"$f":"IF(AND('RWJF Population Model'!$AO$25<>\"\",'RWJF Population Model'!$AO$23<>\"\",'RWJF Population Model'!$AO$36<>\"\",'RWJF Population Model'!$AO$40<>\"\"),SUMIF(Input!$IQ$2:$IQ$25001,1,Input!$LR$2:$LR$25001),0)","v":0},{"$f":"IF(T21>='RWJF Population Model'!$AO$40,W21,0)","v":0},"",null,null,null,null,null,null,null,null,null,null,"COAGULATION DEFECTS",0,0,0,0,0,null,null,null,null,null,null,null,null,null,16,"COAGULATION DEFECTS",0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,16,{"$f":"IF(AND('RWJF Population Model'!$AO$25<>\"\",'RWJF Population Model'!$AO$23<>\"\",'RWJF Population Model'!$AO$36=\"\",'RWJF Population Model'!$AO$40=\"\"),SUMIF(Input!$IQ$2:$IQ$25001,1,Input!$LS$2:$LS$25001),0)","v":0},{"$f":"IF(AND('RWJF Population Model'!$AO$25<>\"\",'RWJF Population Model'!$AO$23<>\"\",'RWJF Population Model'!$AO$36<>\"\",'RWJF Population Model'!$AO$40=\"\"),SUMIF(Input!$IQ$2:$IQ$25001,1,Input!$LS$2:$LS$25001),0)","v":1},{"$f":"IF(AND('RWJF Population Model'!$AO$25<>\"\",'RWJF Population Model'!$AO$23<>\"\",'RWJF Population Model'!$AO$36<>\"\",'RWJF Population Model'!$AO$40<>\"\"),SUMIF(Input!$IQ$2:$IQ$25001,1,Input!$LS$2:$LS$25001),0)","v":0},{"$f":"IF(T22>='RWJF Population Model'!$AO$40,W22,0)","v":0},1,null,null,null,null,null,null,null,null,null,null,"ATRIAL FIBRILLATION",0,0,0,0,0,null,null,null,null,null,null,null,null,null,17,"ATRIAL FIBRILLATION",0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,17,{"$f":"IF(AND('RWJF Population Model'!$AO$25<>\"\",'RWJF Population Model'!$AO$23<>\"\",'RWJF Population Model'!$AO$36=\"\",'RWJF Population Model'!$AO$40=\"\"),SUMIF(Input!$IQ$2:$IQ$25001,1,Input!$LT$2:$LT$25001),0)","v":0},{"$f":"IF(AND('RWJF Population Model'!$AO$25<>\"\",'RWJF Population Model'!$AO$23<>\"\",'RWJF Population Model'!$AO$36<>\"\",'RWJF Population Model'!$AO$40=\"\"),SUMIF(Input!$IQ$2:$IQ$25001,1,Input!$LT$2:$LT$25001),0)","v":0},{"$f":"IF(AND('RWJF Population Model'!$AO$25<>\"\",'RWJF Population Model'!$AO$23<>\"\",'RWJF Population Model'!$AO$36<>\"\",'RWJF Population Model'!$AO$40<>\"\"),SUMIF(Input!$IQ$2:$IQ$25001,1,Input!$LT$2:$LT$25001),0)","v":0},{"$f":"IF(T23>='RWJF Population Model'!$AO$40,W23,0)","v":0},"",null,null,null,null,null,null,null,null,null,null,"COPD",0,0,0,0,0,null,null,null,null,null,null,null,null,null,18,"COPD",0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18,{"$f":"IF(AND('RWJF Population Model'!$AO$25<>\"\",'RWJF Population Model'!$AO$23<>\"\",'RWJF Population Model'!$AO$36=\"\",'RWJF Population Model'!$AO$40=\"\"),SUMIF(Input!$IQ$2:$IQ$25001,1,Input!$LU$2:$LU$25001),0)","v":0},{"$f":"IF(AND('RWJF Population Model'!$AO$25<>\"\",'RWJF Population Model'!$AO$23<>\"\",'RWJF Population Model'!$AO$36<>\"\",'RWJF Population Model'!$AO$40=\"\"),SUMIF(Input!$IQ$2:$IQ$25001,1,Input!$LU$2:$LU$25001),0)","v":0},{"$f":"IF(AND('RWJF Population Model'!$AO$25<>\"\",'RWJF Population Model'!$AO$23<>\"\",'RWJF Population Model'!$AO$36<>\"\",'RWJF Population Model'!$AO$40<>\"\"),SUMIF(Input!$IQ$2:$IQ$25001,1,Input!$LU$2:$LU$25001),0)","v":0},{"$f":"IF(T24>='RWJF Population Model'!$AO$40,W24,0)","v":0},"",null,null,null,null,null,null,null,null,null,null,"LIVER DISEASE",0,0,0,0,0,null,null,null,null,null,null,null,null,null,19,"LIVER DISEASE",0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,19,{"$f":"IF(AND('RWJF Population Model'!$AO$25<>\"\",'RWJF Population Model'!$AO$23<>\"\",'RWJF Population Model'!$AO$36=\"\",'RWJF Population Model'!$AO$40=\"\"),SUMIF(Input!$IQ$2:$IQ$25001,1,Input!$LV$2:$LV$25001),0)","v":0},{"$f":"IF(AND('RWJF Population Model'!$AO$25<>\"\",'RWJF Population Model'!$AO$23<>\"\",'RWJF Population Model'!$AO$36<>\"\",'RWJF Population Model'!$AO$40=\"\"),SUMIF(Input!$IQ$2:$IQ$25001,1,Input!$LV$2:$LV$25001),0)","v":1},{"$f":"IF(AND('RWJF Population Model'!$AO$25<>\"\",'RWJF Population Model'!$AO$23<>\"\",'RWJF Population Model'!$AO$36<>\"\",'RWJF Population Model'!$AO$40<>\"\"),SUMIF(Input!$IQ$2:$IQ$25001,1,Input!$LV$2:$LV$25001),0)","v":0},{"$f":"IF(T25>='RWJF Population Model'!$AO$40,W25,0)","v":0},1,null,null,null,null,null,null,null,null,null,null,"CYSTIC FIBROSIS",0,0,0,0,0,null,null,null,null,null,null,null,null,null,20,"CYSTIC FIBROSIS",0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,20,{"$f":"IF(AND('RWJF Population Model'!$AO$25<>\"\",'RWJF Population Model'!$AO$23<>\"\",'RWJF Population Model'!$AO$36=\"\",'RWJF Population Model'!$AO$40=\"\"),SUMIF(Input!$IQ$2:$IQ$25001,1,Input!$LW$2:$LW$25001),0)","v":0},{"$f":"IF(AND('RWJF Population Model'!$AO$25<>\"\",'RWJF Population Model'!$AO$23<>\"\",'RWJF Population Model'!$AO$36<>\"\",'RWJF Population Model'!$AO$40=\"\"),SUMIF(Input!$IQ$2:$IQ$25001,1,Input!$LW$2:$LW$25001),0)","v":0},{"$f":"IF(AND('RWJF Population Model'!$AO$25<>\"\",'RWJF Population Model'!$AO$23<>\"\",'RWJF Population Model'!$AO$36<>\"\",'RWJF Population Model'!$AO$40<>\"\"),SUMIF(Input!$IQ$2:$IQ$25001,1,Input!$LW$2:$LW$25001),0)","v":0},{"$f":"IF(T26>='RWJF Population Model'!$AO$40,W26,0)","v":0},"",null,null,null,null,null,null,null,null,null,null,"MIGRAINE",0,1,2.0833333333333332E-2,0,0,null,null,null,null,null,null,null,null,null,21,"MIGRAINE",1,0,0,2.0833333333333332E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,21,{"$f":"IF(AND('RWJF Population Model'!$AO$25<>\"\",'RWJF Population Model'!$AO$23<>\"\",'RWJF Population Model'!$AO$36=\"\",'RWJF Population Model'!$AO$40=\"\"),SUMIF(Input!$IQ$2:$IQ$25001,1,Input!$LX$2:$LX$25001),0)","v":0},{"$f":"IF(AND('RWJF Population Model'!$AO$25<>\"\",'RWJF Population Model'!$AO$23<>\"\",'RWJF Population Model'!$AO$36<>\"\",'RWJF Population Model'!$AO$40=\"\"),SUMIF(Input!$IQ$2:$IQ$25001,1,Input!$LX$2:$LX$25001),0)","v":0},{"$f":"IF(AND('RWJF Population Model'!$AO$25<>\"\",'RWJF Population Model'!$AO$23<>\"\",'RWJF Population Model'!$AO$36<>\"\",'RWJF Population Model'!$AO$40<>\"\"),SUMIF(Input!$IQ$2:$IQ$25001,1,Input!$LX$2:$LX$25001),0)","v":0},{"$f":"IF(T27>='RWJF Population Model'!$AO$40,W27,0)","v":0},"",null,null,null,null,null,null,null,null,null,null,"MULTIPLE SCLEROSIS",0,0,0,0,0,null,null,null,null,null,null,null,null,null,22,"MULTIPLE SCLEROSIS",0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,22,{"$f":"IF(AND('RWJF Population Model'!$AO$25<>\"\",'RWJF Population Model'!$AO$23<>\"\",'RWJF Population Model'!$AO$36=\"\",'RWJF Population Model'!$AO$40=\"\"),SUMIF(Input!$IQ$2:$IQ$25001,1,Input!$LY$2:$LY$25001),0)","v":0},{"$f":"IF(AND('RWJF Population Model'!$AO$25<>\"\",'RWJF Population Model'!$AO$23<>\"\",'RWJF Population Model'!$AO$36<>\"\",'RWJF Population Model'!$AO$40=\"\"),SUMIF(Input!$IQ$2:$IQ$25001,1,Input!$LY$2:$LY$25001),0)","v":0},{"$f":"IF(AND('RWJF Population Model'!$AO$25<>\"\",'RWJF Population Model'!$AO$23<>\"\",'RWJF Population Model'!$AO$36<>\"\",'RWJF Population Model'!$AO$40<>\"\"),SUMIF(Input!$IQ$2:$IQ$25001,1,Input!$LY$2:$LY$25001),0)","v":0},{"$f":"IF(T28>='RWJF Population Model'!$AO$40,W28,0)","v":0},"",null,null,null,null,null,null,null,null,null,null,"CAD",0,0,0,0,0,null,null,null,null,null,null,null,null,null,23,"CAD",0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,23,{"$f":"IF(AND('RWJF Population Model'!$AO$25<>\"\",'RWJF Population Model'!$AO$23<>\"\",'RWJF Population Model'!$AO$36=\"\",'RWJF Population Model'!$AO$40=\"\"),SUMIF(Input!$IQ$2:$IQ$25001,1,Input!$LZ$2:$LZ$25001),0)","v":0},{"$f":"IF(AND('RWJF Population Model'!$AO$25<>\"\",'RWJF Population Model'!$AO$23<>\"\",'RWJF Population Model'!$AO$36<>\"\",'RWJF Population Model'!$AO$40=\"\"),SUMIF(Input!$IQ$2:$IQ$25001,1,Input!$LZ$2:$LZ$25001),0)","v":0},{"$f":"IF(AND('RWJF Population Model'!$AO$25<>\"\",'RWJF Population Model'!$AO$23<>\"\",'RWJF Population Model'!$AO$36<>\"\",'RWJF Population Model'!$AO$40<>\"\"),SUMIF(Input!$IQ$2:$IQ$25001,1,Input!$LZ$2:$LZ$25001),0)","v":0},{"$f":"IF(T29>='RWJF Population Model'!$AO$40,W29,0)","v":0},"",null,null,null,null,null,null,null,null,null,null,"MUSCULAR DYSTROPHY",0,0,0,0,0,null,null,null,null,null,null,null,null,null,24,"MUSCULAR DYSTROPHY",0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,24,{"$f":"IF(AND('RWJF Population Model'!$AO$25<>\"\",'RWJF Population Model'!$AO$23<>\"\",'RWJF Population Model'!$AO$36=\"\",'RWJF Population Model'!$AO$40=\"\"),SUMIF(Input!$IQ$2:$IQ$25001,1,Input!$MA$2:$MA$25001),0)","v":0},{"$f":"IF(AND('RWJF Population Model'!$AO$25<>\"\",'RWJF Population Model'!$AO$23<>\"\",'RWJF Population Model'!$AO$36<>\"\",'RWJF Population Model'!$AO$40=\"\"),SUMIF(Input!$IQ$2:$IQ$25001,1,Input!$MA$2:$MA$25001),0)","v":0},{"$f":"IF(AND('RWJF Population Model'!$AO$25<>\"\",'RWJF Population Model'!$AO$23<>\"\",'RWJF Population Model'!$AO$36<>\"\",'RWJF Population Model'!$AO$40<>\"\"),SUMIF(Input!$IQ$2:$IQ$25001,1,Input!$MA$2:$LIC$25001),0)","v":0},{"$f":"IF(T30>='RWJF Population Model'!$AO$40,W30,0)","v":0},"",null,null,null,null,null,null,null,null,null,null,"MYASTHENIA GRAVIS",0,0,0,0,0,null,null,null,null,null,null,null,null,null,25,"MYASTHENIA GRAVIS",0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EPILEPSY",0,1,2.0833333333333332E-2,0,0,null,null,null,null,null,null,null,null,null,26,"EPILEPSY",1,0,0,2.0833333333333332E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N=",{"$f":"SUM(Y6:Y30)-SUM(X6:X30)","v":18},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"OSTEOARTHRITIS",0,0,0,0,0,null,null,null,null,null,null,null,null,null,27,"OSTEOARTHRITIS",0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(U33<>\"\",T32,\"\")","v":""},{"$f":"IF(SUM(W6:W30)=0,\"\",SUM(W6:W30)-U32)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ESRD",0,0,0,0,0,null,null,null,null,null,null,null,null,null,28,"ESRD",0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PANCREATITIS CHRONIC",0,0,0,0,0,null,null,null,null,null,null,null,null,null,29,"PANCREATITIS CHRONIC",0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HEMATOLOGICAL SICKLE CELL",0,0,0,0,0,null,null,null,null,null,null,null,null,null,30,"HEMATOLOGICAL SICKLE CELL",0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PARKINSONS DISEASE",0,0,0,0,0,null,null,null,null,null,null,null,null,null,31,"PARKINSONS DISEASE",0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HIV",0,0,0,0,0,null,null,null,null,null,null,null,null,null,32,"HIV",0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RHEUMA ARTHRITIS",0,1,2.0833333333333332E-2,0,0,null,null,null,null,null,null,null,null,null,33,"RHEUMA ARTHRITIS",1,0,0,2.0833333333333332E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HYPERLIPIDEMIA",0,0,0,0,0,null,null,null,null,null,null,null,null,null,34,"HYPERLIPIDEMIA",0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TRANSPLANT",0,0,0,0,0,null,null,null,null,null,null,null,null,null,35,"TRANSPLANT",0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HYPERTENSION",0,1,2.0833333333333332E-2,0,0,null,null,null,null,null,null,null,null,null,36,"HYPERTENSION",1,0,0,2.0833333333333332E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"IMMUNE DEFICIENCY",0,0,0,0,0,null,null,null,null,null,null,null,null,null,37,"IMMUNE DEFICIENCY",0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Grand Total",null,null,null,null,7.1527385159010599]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CC Rank & Bubble"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rank","CC","Total Spend","PMPM","Occurences","Prevalence","Size"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"CENTRAL NERV SYS DISEASE",{"$f":"SUMIF(Input!$IP$2:$IP$25001,1,Input!$HJ$2:$HJ$25001)","v":0},{"$f":"SUMIF(Input!$IP$2:$IP$25001,1,Input!$HJ$2:$HJ$25001)/SUMIF(Input!$IP$2:$IP$25001,1,Input!$ER$2:$ER$25001)","v":0},{"$f":"SUMIF(Input!$IP$2:$IP$25001,1,Input!$FE$2:$FE$25001)","v":1},{"$f":"AN106/'RWJF Population Model'!$Z$47","v":5.5555555555555552E-2},{"$f":"IFERROR(AL106/SUM($AN$106:$AN$142),0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,"CEREBRAL PALSY",{"$f":"SUMIF(Input!$IP$2:$IP$25001,1,Input!$HK$2:$HK$25001)","v":0},{"$f":"SUMIF(Input!$IP$2:$IP$25001,1,Input!$HK$2:$HK$25001)/SUMIF(Input!$IP$2:$IP$25001,1,Input!$ER$2:$ER$25001)","v":0},{"$f":"SUMIF(Input!$IP$2:$IP$25001,1,Input!$FF$2:$FF$25001)","v":0},{"$f":"AN107/'RWJF Population Model'!$Z$47","v":0},0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,"MUSCULAR DYSTROPHY",{"$f":"SUMIF(Input!$IP$2:$IP$25001,1,Input!$HY$2:$HY$25001)","v":0},{"$f":"SUMIF(Input!$IP$2:$IP$25001,1,Input!$HY$2:$HY$25001)/SUMIF(Input!$IP$2:$IP$25001,1,Input!$ER$2:$ER$25001)","v":0},{"$f":"SUMIF(Input!$IP$2:$IP$25001,1,Input!$FT$2:$FT$25001)","v":0},{"$f":"AN108/'RWJF Population Model'!$Z$47","v":0},0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,"NEOPLASM MALIGNANT",{"$f":"SUMIF(Input!$IP$2:$IP$25001,1,Input!$IA$2:$IA$25001)","v":0},{"$f":"SUMIF(Input!$IP$2:$IP$25001,1,Input!$IA$2:$IA$25001)/SUMIF(Input!$IP$2:$IP$25001,1,Input!$ER$2:$ER$25001)","v":0},{"$f":"SUMIF(Input!$IP$2:$IP$25001,1,Input!$FV$2:$FV$25001)","v":0},{"$f":"AN109/'RWJF Population Model'!$Z$47","v":0},0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,"DM",{"$f":"SUMIF(Input!$IP$2:$IP$25001,1,Input!$HB$2:$HB$25001)","v":616.32000000000005},{"$f":"SUMIF(Input!$IP$2:$IP$25001,1,Input!$HB$2:$HB$25001)/SUMIF(Input!$IP$2:$IP$25001,1,Input!$ER$2:$ER$25001)","v":2.9630769230769234},{"$f":"SUMIF(Input!$IP$2:$IP$25001,1,Input!$EW$2:$EW$25001)","v":1},{"$f":"AN110/'RWJF Population Model'!$Z$47","v":5.5555555555555552E-2},47.409230769230774]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,"HEMATOLOGICAL SICKLE CELL",{"$f":"SUMIF(Input!$IP$2:$IP$25001,1,Input!$HR$2:$HR$25001)","v":0},{"$f":"SUMIF(Input!$IP$2:$IP$25001,1,Input!$HR$2:$HR$25001)/SUMIF(Input!$IP$2:$IP$25001,1,Input!$ER$2:$ER$25001)","v":0},{"$f":"SUMIF(Input!$IP$2:$IP$25001,1,Input!$FM$2:$FM$25001)","v":0},{"$f":"AN111/'RWJF Population Model'!$Z$47","v":0},0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,"INFLAMMATORY BOWEL DISEASE",{"$f":"SUMIF(Input!$IP$2:$IP$25001,1,Input!$HU$2:$HU$25001)","v":0},{"$f":"SUMIF(Input!$IP$2:$IP$25001,1,Input!$HU$2:$HU$25001)/SUMIF(Input!$IP$2:$IP$25001,1,Input!$ER$2:$ER$25001)","v":0},{"$f":"SUMIF(Input!$IP$2:$IP$25001,1,Input!$FP$2:$FP$25001)","v":0},{"$f":"AN112/'RWJF Population Model'!$Z$47","v":0},0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,"PARALYSIS",{"$f":"SUMIF(Input!$IP$2:$IP$25001,1,Input!$ID$2:$ID$25001)","v":0},{"$f":"SUMIF(Input!$IP$2:$IP$25001,1,Input!$ID$2:$ID$25001)/SUMIF(Input!$IP$2:$IP$25001,1,Input!$ER$2:$ER$25001)","v":0},{"$f":"SUMIF(Input!$IP$2:$IP$25001,1,Input!$FY$2:$FY$25001)","v":0},{"$f":"AN113/'RWJF Population Model'!$Z$47","v":0},0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,"EPILEPSY",{"$f":"SUMIF(Input!$IP$2:$IP$25001,1,Input!$HP$2:$HP$25001)","v":0},{"$f":"SUMIF(Input!$IP$2:$IP$25001,1,Input!$HP$2:$HP$25001)/SUMIF(Input!$IP$2:$IP$25001,1,Input!$ER$2:$ER$25001)","v":0},{"$f":"SUMIF(Input!$IP$2:$IP$25001,1,Input!$FK$2:$FK$25001)","v":1},{"$f":"AN114/'RWJF Population Model'!$Z$47","v":5.5555555555555552E-2},0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,"SPINA BIFIDA SCI",{"$f":"SUMIF(Input!$IP$2:$IP$25001,1,Input!$IH$2:$IH$25001)","v":0},{"$f":"SUMIF(Input!$IP$2:$IP$25001,1,Input!$IH$2:$IH$25001)/SUMIF(Input!$IP$2:$IP$25001,1,Input!$ER$2:$ER$25001)","v":0},{"$f":"SUMIF(Input!$IP$2:$IP$25001,1,Input!$GC$2:$GC$25001)","v":0},{"$f":"AN115/'RWJF Population Model'!$Z$47","v":0},0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,11,"ASTHMA",{"$f":"SUMIF(Input!$IP$2:$IP$25001,1,Input!$GX$2:$GX$25001)","v":3431.9500000000003},{"$f":"SUMIF(Input!$IP$2:$IP$25001,1,Input!$GX$2:$GX$25001)/SUMIF(Input!$IP$2:$IP$25001,1,Input!$ER$2:$ER$25001)","v":16.499759615384615},{"$f":"SUMIF(Input!$IP$2:$IP$25001,1,Input!$ES$2:$ES$25001)","v":8},{"$f":"AN116/'RWJF Population Model'!$Z$47","v":0.44444444444444442},263.99615384615385]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,12,"ESRD",{"$f":"SUMIF(Input!$IP$2:$IP$25001,1,Input!$HQ$2:$HQ$25001)","v":0},{"$f":"SUMIF(Input!$IP$2:$IP$25001,1,Input!$HQ$2:$HQ$25001)/SUMIF(Input!$IP$2:$IP$25001,1,Input!$ER$2:$ER$25001)","v":0},{"$f":"SUMIF(Input!$IP$2:$IP$25001,1,Input!$FL$2:$FL$25001)","v":0},{"$f":"AN117/'RWJF Population Model'!$Z$47","v":0},0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,13,"MYASTHENIA GRAVIS",{"$f":"SUMIF(Input!$IP$2:$IP$25001,1,Input!$HZ$2:$HZ$25001)","v":0},{"$f":"SUMIF(Input!$IP$2:$IP$25001,1,Input!$HZ$2:$HZ$25001)/SUMIF(Input!$IP$2:$IP$25001,1,Input!$ER$2:$ER$25001)","v":0},{"$f":"SUMIF(Input!$IP$2:$IP$25001,1,Input!$FU$2:$FU$25001)","v":0},{"$f":"AN118/'RWJF Population Model'!$Z$47","v":0},0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,14,"COPD",{"$f":"SUMIF(Input!$IP$2:$IP$25001,1,Input!$GY$2:$GY$25001)","v":0},{"$f":"SUMIF(Input!$IP$2:$IP$25001,1,Input!$GY$2:$GY$25001)/SUMIF(Input!$IP$2:$IP$25001,1,Input!$ER$2:$ER$25001)","v":0},{"$f":"SUMIF(Input!$IP$2:$IP$25001,1,Input!$ET$2:$ET$25001)","v":0},{"$f":"AN119/'RWJF Population Model'!$Z$47","v":0},0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15,"TRANSPLANT",{"$f":"SUMIF(Input!$IP$2:$IP$25001,1,Input!$IG$2:$IG$25001)","v":0},{"$f":"SUMIF(Input!$IP$2:$IP$25001,1,Input!$IG$2:$IG$25001)/SUMIF(Input!$IP$2:$IP$25001,1,Input!$ER$2:$ER$25001)","v":0},{"$f":"SUMIF(Input!$IP$2:$IP$25001,1,Input!$GB$2:$GB$25001)","v":0},{"$f":"AN120/'RWJF Population Model'!$Z$47","v":0},0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,16,"RHEUMA ARTHRITIS",{"$f":"SUMIF(Input!$IP$2:$IP$25001,1,Input!$HF$2:$HF$25001)","v":0},{"$f":"SUMIF(Input!$IP$2:$IP$25001,1,Input!$HF$2:$HF$25001)/SUMIF(Input!$IP$2:$IP$25001,1,Input!$ER$2:$ER$25001)","v":0},{"$f":"SUMIF(Input!$IP$2:$IP$25001,1,Input!$FA$2:$FA$25001)","v":1},{"$f":"AN121/'RWJF Population Model'!$Z$47","v":5.5555555555555552E-2},0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,17,"COAGULATION DEFECTS",{"$f":"SUMIF(Input!$IP$2:$IP$25001,1,Input!$HN$2:$HN$25001)","v":0},{"$f":"SUMIF(Input!$IP$2:$IP$25001,1,Input!$HN$2:$HN$25001)/SUMIF(Input!$IP$2:$IP$25001,1,Input!$ER$2:$ER$25001)","v":0},{"$f":"SUMIF(Input!$IP$2:$IP$25001,1,Input!$FI$2:$FI$25001)","v":0},{"$f":"AN122/'RWJF Population Model'!$Z$47","v":0},0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18,"MIGRAINE",{"$f":"SUMIF(Input!$IP$2:$IP$25001,1,Input!$HW$2:$HW$25001)","v":0},{"$f":"SUMIF(Input!$IP$2:$IP$25001,1,Input!$HW$2:$HW$25001)/SUMIF(Input!$IP$2:$IP$25001,1,Input!$ER$2:$ER$25001)","v":0},{"$f":"SUMIF(Input!$IP$2:$IP$25001,1,Input!$FR$2:$FR$25001)","v":0},{"$f":"AN123/'RWJF Population Model'!$Z$47","v":0},0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,19,"LIVER DISEASE",{"$f":"SUMIF(Input!$IP$2:$IP$25001,1,Input!$HV$2:$HV$25001)","v":0},{"$f":"SUMIF(Input!$IP$2:$IP$25001,1,Input!$HV$2:$HV$25001)/SUMIF(Input!$IP$2:$IP$25001,1,Input!$ER$2:$ER$25001)","v":0},{"$f":"SUMIF(Input!$IP$2:$IP$25001,1,Input!$FQ$2:$FQ$25001)","v":0},{"$f":"AN124/'RWJF Population Model'!$Z$47","v":0},0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,20,"IMMUNE DEFICIENCY",{"$f":"SUMIF(Input!$IP$2:$IP$25001,1,Input!$HT$2:$HT$25001)","v":0},{"$f":"SUMIF(Input!$IP$2:$IP$25001,1,Input!$HT$2:$HT$25001)/SUMIF(Input!$IP$2:$IP$25001,1,Input!$ER$2:$ER$25001)","v":0},{"$f":"SUMIF(Input!$IP$2:$IP$25001,1,Input!$FO$2:$FO$25001)","v":0},{"$f":"AN125/'RWJF Population Model'!$Z$47","v":0},0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,21,"CEREBRO VASCULAR DISEASE",{"$f":"SUMIF(Input!$IP$2:$IP$25001,1,Input!$HL$2:$HL$25001)","v":0},{"$f":"SUMIF(Input!$IP$2:$IP$25001,1,Input!$HL$2:$HL$25001)/SUMIF(Input!$IP$2:$IP$25001,1,Input!$ER$2:$ER$25001)","v":0},{"$f":"SUMIF(Input!$IP$2:$IP$25001,1,Input!$FG$2:$FG$25001)","v":0},{"$f":"AN126/'RWJF Population Model'!$Z$47","v":0},0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,22,"HYPERTENSION",{"$f":"SUMIF(Input!$IP$2:$IP$25001,1,Input!$HE$2:$HE$25001)","v":0},{"$f":"SUMIF(Input!$IP$2:$IP$25001,1,Input!$HE$2:$HE$25001)/SUMIF(Input!$IP$2:$IP$25001,1,Input!$ER$2:$ER$25001)","v":0},{"$f":"SUMIF(Input!$IP$2:$IP$25001,1,Input!$EZ$2:$EZ$25001)","v":1},{"$f":"AN127/'RWJF Population Model'!$Z$47","v":5.5555555555555552E-2},0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,23,"CYSTIC FIBROSIS",{"$f":"SUMIF(Input!$IP$2:$IP$25001,1,Input!$HO$2:$HO$25001)","v":0},{"$f":"SUMIF(Input!$IP$2:$IP$25001,1,Input!$HO$2:$HO$25001)/SUMIF(Input!$IP$2:$IP$25001,1,Input!$ER$2:$ER$25001)","v":0},{"$f":"SUMIF(Input!$IP$2:$IP$25001,1,Input!$FJ$2:$FJ$25001)","v":0},{"$f":"AN128/'RWJF Population Model'!$Z$47","v":0},0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,24,"RENAL DISEASE",{"$f":"SUMIF(Input!$IP$2:$IP$25001,1,Input!$IF$2:$IF$25001)","v":0},{"$f":"SUMIF(Input!$IP$2:$IP$25001,1,Input!$IF$2:$IF$25001)/SUMIF(Input!$IP$2:$IP$25001,1,Input!$ER$2:$ER$25001)","v":0},{"$f":"SUMIF(Input!$IP$2:$IP$25001,1,Input!$GA$2:$GA$25001)","v":0},{"$f":"AN129/'RWJF Population Model'!$Z$47","v":0},0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,25,"LUPUS CONN TISSUE DISORDERS",{"$f":"SUMIF(Input!$IP$2:$IP$25001,1,Input!$HH$2:$HH$25001)","v":0},{"$f":"SUMIF(Input!$IP$2:$IP$25001,1,Input!$HH$2:$HH$25001)/SUMIF(Input!$IP$2:$IP$25001,1,Input!$ER$2:$ER$25001)","v":0},{"$f":"SUMIF(Input!$IP$2:$IP$25001,1,Input!$FC$2:$FC$25001)","v":0},{"$f":"AN130/'RWJF Population Model'!$Z$47","v":0},0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,26,"HIV",{"$f":"SUMIF(Input!$IP$2:$IP$25001,1,Input!$HS$2:$HS$25001)","v":0},{"$f":"SUMIF(Input!$IP$2:$IP$25001,1,Input!$HS$2:$HS$25001)/SUMIF(Input!$IP$2:$IP$25001,1,Input!$ER$2:$ER$25001)","v":0},{"$f":"SUMIF(Input!$IP$2:$IP$25001,1,Input!$FN$2:$FN$25001)","v":0},{"$f":"AN131/'RWJF Population Model'!$Z$47","v":0},0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,27,"MULTIPLE SCLEROSIS",{"$f":"SUMIF(Input!$IP$2:$IP$25001,1,Input!$HX$2:$HX$25001)","v":0},{"$f":"SUMIF(Input!$IP$2:$IP$25001,1,Input!$HX$2:$HX$25001)/SUMIF(Input!$IP$2:$IP$25001,1,Input!$ER$2:$ER$25001)","v":0},{"$f":"SUMIF(Input!$IP$2:$IP$25001,1,Input!$FS$2:$FS$25001)","v":0},{"$f":"AN132/'RWJF Population Model'!$Z$47","v":0},0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,28,"CAD",{"$f":"SUMIF(Input!$IP$2:$IP$25001,1,Input!$HA$2:$HA$25001)","v":0},{"$f":"SUMIF(Input!$IP$2:$IP$25001,1,Input!$HA$2:$HA$25001)/SUMIF(Input!$IP$2:$IP$25001,1,Input!$ER$2:$ER$25001)","v":0},{"$f":"SUMIF(Input!$IP$2:$IP$25001,1,Input!$EV$2:$EV$25001)","v":0},{"$f":"AN133/'RWJF Population Model'!$Z$47","v":0},0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,29,"OSTEOARTHRITIS",{"$f":"SUMIF(Input!$IP$2:$IP$25001,1,Input!$HG$2:$HG$25001)","v":0},{"$f":"SUMIF(Input!$IP$2:$IP$25001,1,Input!$HG$2:$HG$25001)/SUMIF(Input!$IP$2:$IP$25001,1,Input!$ER$2:$ER$25001)","v":0},{"$f":"SUMIF(Input!$IP$2:$IP$25001,1,Input!$FB$2:$FB$25001)","v":0},{"$f":"AN134/'RWJF Population Model'!$Z$47","v":0},0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,30,"CHRONIC HEPATITIS",{"$f":"SUMIF(Input!$IP$2:$IP$25001,1,Input!$HM$2:$HM$25001)","v":0},{"$f":"SUMIF(Input!$IP$2:$IP$25001,1,Input!$HM$2:$HM$25001)/SUMIF(Input!$IP$2:$IP$25001,1,Input!$ER$2:$ER$25001)","v":0},{"$f":"SUMIF(Input!$IP$2:$IP$25001,1,Input!$FH$2:$FH$25001)","v":0},{"$f":"AN135/'RWJF Population Model'!$Z$47","v":0},0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,31,"OSTEOPOROSIS",{"$f":"SUMIF(Input!$IP$2:$IP$25001,1,Input!$IB$2:$IB$25001)","v":0},{"$f":"SUMIF(Input!$IP$2:$IP$25001,1,Input!$IB$2:$IB$25001)/SUMIF(Input!$IP$2:$IP$25001,1,Input!$ER$2:$ER$25001)","v":0},{"$f":"SUMIF(Input!$IP$2:$IP$25001,1,Input!$FW$2:$FW$25001)","v":0},{"$f":"AN136/'RWJF Population Model'!$Z$47","v":0},0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,32,"HYPERLIPIDEMIA",{"$f":"SUMIF(Input!$IP$2:$IP$25001,1,Input!$HD$2:$HD$25001)","v":0},{"$f":"SUMIF(Input!$IP$2:$IP$25001,1,Input!$HD$2:$HD$25001)/SUMIF(Input!$IP$2:$IP$25001,1,Input!$ER$2:$ER$25001)","v":0},{"$f":"SUMIF(Input!$IP$2:$IP$25001,1,Input!$EY$2:$EY$25001)","v":0},{"$f":"AN137/'RWJF Population Model'!$Z$47","v":0},0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,33,"CHF",{"$f":"SUMIF(Input!$IP$2:$IP$25001,1,Input!$GZ$2:$GZ$25001)","v":0},{"$f":"SUMIF(Input!$IP$2:$IP$25001,1,Input!$GZ$2:$GZ$25001)/SUMIF(Input!$IP$2:$IP$25001,1,Input!$ER$2:$ER$25001)","v":0},{"$f":"SUMIF(Input!$IP$2:$IP$25001,1,Input!$EU$2:$EU$25001)","v":0},{"$f":"AN138/'RWJF Population Model'!$Z$47","v":0},0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,34,"MORBID OBESITY",{"$f":"SUMIF(Input!$IP$2:$IP$25001,1,Input!$HC$2:$HC$25001)","v":0},{"$f":"SUMIF(Input!$IP$2:$IP$25001,1,Input!$HC$2:$HC$25001)/SUMIF(Input!$IP$2:$IP$25001,1,Input!$ER$2:$ER$25001)","v":0},{"$f":"SUMIF(Input!$IP$2:$IP$25001,1,Input!$EX$2:$EX$25001)","v":0},{"$f":"AN139/'RWJF Population Model'!$Z$47","v":0},0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,35,"ATRIAL FIBRILLATION",{"$f":"SUMIF(Input!$IP$2:$IP$25001,1,Input!$HI$2:$HI$25001)","v":0},{"$f":"SUMIF(Input!$IP$2:$IP$25001,1,Input!$HI$2:$HI$25001)/SUMIF(Input!$IP$2:$IP$25001,1,Input!$ER$2:$ER$25001)","v":0},{"$f":"SUMIF(Input!$IP$2:$IP$25001,1,Input!$FD$2:$FD$25001)","v":0},{"$f":"AN140/'RWJF Population Model'!$Z$47","v":0},0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,36,"PANCREATITIS CHRONIC",{"$f":"SUMIF(Input!$IP$2:$IP$25001,1,Input!$IC$2:$IC$25001)","v":0},{"$f":"SUMIF(Input!$IP$2:$IP$25001,1,Input!$IC$2:$IC$25001)/SUMIF(Input!$IP$2:$IP$25001,1,Input!$ER$2:$ER$25001)","v":0},{"$f":"SUMIF(Input!$IP$2:$IP$25001,1,Input!$FX$2:$FX$25001)","v":0},{"$f":"AN141/'RWJF Population Model'!$Z$47","v":0},0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,37,"PARKINSONS DISEASE",{"$f":"SUMIF(Input!$IP$2:$IP$25001,1,Input!$IE$2:$IE$25001)","v":0},{"$f":"SUMIF(Input!$IP$2:$IP$25001,1,Input!$IE$2:$IE$25001)/SUMIF(Input!$IP$2:$IP$25001,1,Input!$ER$2:$ER$25001)","v":0},{"$f":"SUMIF(Input!$IP$2:$IP$25001,1,Input!$FZ$2:$FZ$25001)","v":0},{"$f":"AN142/'RWJF Population Model'!$Z$47","v":0},0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AL106:AL142)","v":4048.2700000000004},null,{"$f":"SUM(AN106:AN142)","v":13}]